openlink/mcp-server-sqlalchemy

Overview

A simple MCP server that uses FastAPI, ODBC, and SQLAlchemy to expose databases to AI models via the Model Context Protocol. It translates ODBC connections into a standardized interface for MCP-compatible tools.

Best for

Best for
Developers who need a minimal ODBC-to-MCP bridge for AI tool integration

Use cases

• Connecting ODBC databases to MCP-enabled AI assistants
• Running SQL queries through a lightweight Python server
• Providing database access for AI agents via a standardized protocol

How to use

Install

npx @modelcontextprotocol/inspector uv --directory /path/to/mcp-sqlalchemy-server run mcp-sqlalchemy-server

Tools exposed

• podbc_get_schemas
• podbc_get_tables
• podbc_describe_table
• podbc_filter_table_names
• podbc_query_database
• podbc_execute_query
• podbc_execute_query_md
• podbc_spasql_query
• podbc_sparql_query
• podbc_virtuoso_support_ai

Tested with

Claude Desktop

Notes

A simple MCP server that uses FastAPI, ODBC, and SQLAlchemy to expose databases to AI models via the Model Context Protocol. It translates ODBC connections into a standardized interface for MCP-compatible tools.

24 stars on GitHub. Last updated 2025-05-23. Licensed MIT.

Use cases

• Connecting ODBC databases to MCP-enabled AI assistants
• Running SQL queries through a lightweight Python server
• Providing database access for AI agents via a standardized protocol

Pros

• Simple and quick to set up with FastAPI and SQLAlchemy
• Works with any ODBC-compatible database
• Lightweight Python codebase

Cons

• Requires ODBC driver installation and configuration
• Small community with limited documentation
• May not handle high concurrency or complex queries well

Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.