SQLAlchemy
CreatedOpenLinkSoftware
Exposes database schemas and tables via an MCP server using FastAPI, ODBC, and SQLAlchemy.
About
Provides a lightweight Model Context Protocol (MCP) server for ODBC, leveraging FastAPI, pyodbc, and SQLAlchemy to interact with various databases. It fetches schemas, retrieves table information, generates detailed table descriptions, supports table searching, and executes stored procedures and queries. Compatible with Virtuoso DBMS and other SQLAlchemy provider-supported DBMS backends, it facilitates seamless integration with Claude and other applications.
Key Features
- Executes stored procedures and queries
- 7 GitHub stars
- Fetches database schema names
- Filters tables based on name substrings
- Retrieves table information for specific schemas
- Generates detailed table structure descriptions
Use Cases
- Build custom database interaction tools
- Integrate with Claude for database interaction
- Expose database schemas and tables to applications