TypeScript-based Model Context Protocol (MCP) server that exposes ODBC data sources to LLM clients.
https://github.com/OpenLinkSoftware/mcp-odbc-serverStop building custom APIs just to let AI assistants query your databases. This MCP server creates a direct bridge between any ODBC-compatible database and LLM clients, turning your AI tools into powerful database analysts.
You've got valuable data locked in enterprise databases. You want to use Claude, Cursor, or other AI tools to analyze it, generate reports, or answer business questions. But first you need to:
There's a better way.
The MCP ODBC Server eliminates the middleware entirely. Point it at any ODBC data source and your AI tools can immediately:
Works with any ODBC-compatible database: SQL Server, Oracle, MySQL, PostgreSQL, SQLite, and hundreds more.
Business Intelligence Without BI Tools
"Show me our top 10 customers by revenue this quarter,
broken down by product category"
Claude executes the complex JOIN across your sales, customer, and product tables instantly.
Data Quality Auditing
"Find all orders where the shipping date is before the order date"
Your AI assistant becomes a data detective, writing and running validation queries.
Schema Documentation
"Explain the relationship between our Users, Orders, and Products tables"
The server introspects your database structure and AI generates clear documentation.
Ad-Hoc Reporting
"Create a monthly summary of user signups by region for the past year"
No need to build dashboard widgets - get instant custom reports.
The server exposes 10 specialized tools through MCP:
get_schemas / get_tables / describe_table - Database explorationquery_database - Execute SQL with JSON/Markdown/JSONL output formatsfilter_table_names - Smart table discoverysparql_query / spasql_query - Semantic queries (Virtuoso)virtuoso_support_ai - Built-in AI assistant for Virtuoso databasesClaude Desktop - Configure once, query instantly through chat
Cline (VSCode) - Database-driven development workflows
Cursor - AI-powered database exploration while coding
Any MCP Client - Built on the standard Model Context Protocol
Built by OpenLink Software with 30+ years of database connectivity expertise:
# Clone and install
git clone https://github.com/OpenLinkSoftware/mcp-odbc-server.git
cd mcp-odbc-server && npm install
# Configure your database connection
echo "ODBC_DSN=MyDatabase" >> .env
echo "ODBC_USER=myuser" >> .env
echo "ODBC_PASSWORD=mypass" >> .env
# Test with MCP Inspector
npx @modelcontextprotocol/inspector npx tsx ./src/main.ts
Configure Claude Desktop with your server path, and you're querying databases through natural language in minutes.
Instead of maintaining database APIs that become stale, you get:
Your databases become as accessible to AI as they are to your existing applications, but without the integration complexity.
Perfect for data analysts, backend developers, and anyone who needs to bridge the gap between AI assistants and enterprise data stores.