mcp-odbc
1
The ODBC MCP Server allows tools like Claude Desktop to query and analyze database data securely via ODBC connections. It offers features like multiple database connections, read-only safeguards, and flexible configuration options, enhancing data access and analysis while maintaining security.
ODBC MCP Server
An MCP server that enables LLM tools like Claude Desktop to query databases via ODBC connections.
Features
- Connect to any ODBC-compatible database
- Support for multiple connections
- Read-only safeguards
- Easy installation with UV package manager
- Error reporting and logging
Prerequisites
- Python 3.10+
- UV package manager
- ODBC drivers
Configuration
- Use config files, environment variables, or Claude Desktop settings.
Usage
- Start server manually or with Claude Desktop
- Provides tools: list-connections, list-available-dsns, test-connection, list-tables, get-table-schema, execute-query.