mcp-odbc
If you are the rightful owner of mcp-odbc and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
An MCP server that enables LLM tools like Claude Desktop to query databases via ODBC connections.
The ODBC MCP Server is designed to facilitate seamless interaction between large language model (LLM) tools, such as Claude Desktop, and databases through ODBC connections. This server allows users to access, analyze, and generate insights from database data while ensuring security and maintaining read-only safeguards. It supports multiple database connections and offers flexible configuration options, making it a versatile tool for data-driven applications. The server is easy to install using the UV package manager and provides detailed error reporting and logging to assist with troubleshooting.
Features
- Connect to any ODBC-compatible database
- Support for multiple database connections
- Flexible configuration through config files or Claude Desktop settings
- Read-only safeguards to prevent data modification
- Easy installation with UV package manager
Tools
list-connections
Lists all configured database connections
list-available-dsns
Lists all available DSNs on the system
test-connection
Tests a database connection and returns information
list-tables
Lists all tables in the database
get-table-schema
Gets schema information for a table
execute-query
Executes an SQL query and returns results
