---
warning: DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github.com/duckdb/community-extensions repository, check README there
title: nanodbc
excerpt: |
  DuckDB Community Extensions
  Connect to any ODBC-compatible database and query data directly from DuckDB

extension:
  name: nanodbc
  description: Connect to any ODBC-compatible database and query data directly from DuckDB
  version: 0.4.0
  language: C++
  build: cmake
  excluded_platforms: "linux_amd64_musl;osx_amd64;wasm_mvp;wasm_eh;wasm_threads"
  license: MIT
  maintainers:
    - Hugoberry
repo:
  github: Hugoberry/duckdb-nanodbc-extension
  ref: 0740a99bc20a9c5d1c07c39b0779104e5b5b88e5
docs:
  hello_world: |
    -- Query a table using DSN
    SELECT * FROM odbc_scan(table_name='customers', connection='MyODBCDSN');
    
    -- Execute custom SQL with connection string
    SELECT * FROM odbc_query(
        connection='Driver={SQL Server};Server=localhost;Database=mydb;',
        query='SELECT id, name, amount FROM sales WHERE amount > 1000'
    );
    
    -- Attach all tables from an ODBC source
    CALL odbc_attach(connection='MyODBCDSN');
  extended_description: >
    The ODBC extension allows DuckDB to seamlessly connect to any database that provides an ODBC driver,
    enabling you to query and analyze data from a wide variety of data sources without leaving the DuckDB ecosystem.
    
    
    Key features:
    - `odbc_scan()`: Query tables from any ODBC data source
    - `odbc_query()`: Execute custom SQL queries against external databases
    - `odbc_exec()`: Execute DDL/DML statements without returning results
    - `odbc_attach()`: Attach all tables from an ODBC source as views in DuckDB
    - Cross-platform character encoding support
    - Automatic type conversion between ODBC and DuckDB types
    - Support for DSNs and direct connection strings
    
    
    The extension works on Windows, macOS, and Linux platforms and has been tested with SQL Server, MySQL, 
    PostgreSQL, Snowflake, SQLite, and many other databases. All functions use named parameters for better 
    readability and flexibility.

    

extension_star_count: 53
extension_star_count_pretty: 53
extension_download_count: 1335
extension_download_count_pretty: 1.3k
image: '/images/community_extensions/social_preview/preview_community_extension_nanodbc.png'
layout: community_extension_doc
---
### Compatibility Matrix

This table covers all DuckDB releases that have not reached [end-of-life](https://duckdb.org/release_calendar), including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.

<div class="extension_compatibility_table"></div>

| Platform | 1.4.4 | 1.4.5 | 1.5.5 | 1.5.6 | 2.0.0 |
| :--- | :---: | :---: | :---: | :---: | :---: |
| Linux AMD64 | ✅ | ❌ | ❌ | ❌ | ❌ |
| Linux ARM64 | ✅ | ❌ | ❌ | ❌ | ❌ |
| macOS AMD64 | ❌ | ❌ | ❌ | ❌ | ❌ |
| macOS ARM64 | ✅ | ❌ | ❌ | ❌ | ❌ |
| Windows AMD64 | ✅ | ❌ | ❌ | ❌ | ❌ |
| Windows ARM64 | ❌ | ❌ | ❌ | ❌ | ❌ |
| WebAssembly | ❌ | ❌ | ❌ | ❌ | ❌ |

### Installing and Loading
```sql
INSTALL {{ page.extension.name }} FROM community;
LOAD {{ page.extension.name }};
```

{% if page.docs.hello_world %}
### Example
```sql
{{ page.docs.hello_world }}```
{% endif %}

{% if page.docs.extended_description %}
### About {{ page.extension.name }}
{{ page.docs.extended_description }}
{% endif %}
### Added Functions

<div class="extension_functions_table"></div>

| function_name | function_type | description | comment | examples |
|---------------|---------------|-------------|---------|----------|
| odbc_attach   | table         | NULL        | NULL    |          |
| odbc_exec     | table         | NULL        | NULL    |          |
| odbc_query    | table         | NULL        | NULL    |          |
| odbc_scan     | table         | NULL        | NULL    |          |

### Overloaded Functions

<div class="extension_functions_table"></div>

This extension does not add any function overloads.

### Added Types

<div class="extension_types_table"></div>

This extension does not add any types.

### Added Settings

<div class="extension_settings_table"></div>

This extension does not add any settings.