mcp-sqlalchemy-server
If you are the rightful owner of mcp-sqlalchemy-server 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.
A lightweight MCP server for ODBC built with FastAPI, pyodbc, and SQLAlchemy, compatible with Virtuoso DBMS and other DBMS backends.
The MCP Server ODBC via SQLAlchemy is a robust and lightweight server designed to facilitate database interactions using the Model Context Protocol (MCP). Built with FastAPI, pyodbc, and SQLAlchemy, it provides seamless connectivity to various database management systems (DBMS) that support SQLAlchemy providers, including Virtuoso DBMS. The server offers a range of features such as schema and table retrieval, table description, and query execution in multiple formats. It is particularly optimized for structured responses and visualization, making it ideal for reporting and data analysis tasks. The server also supports executing stored procedures and SPARQL queries, especially for Virtuoso DBMS, enhancing its versatility in handling complex database operations. With its easy setup and configuration, the MCP Server ODBC via SQLAlchemy is a valuable tool for developers and data analysts looking to streamline their database management processes.
Features
- Get Schemas: Fetch and list all schema names from the connected database.
- Get Tables: Retrieve table information for specific schemas or all schemas.
- Describe Table: Generate a detailed description of table structures, including column names, data types, nullable attributes, primary and foreign keys.
- Search Tables: Filter and retrieve tables based on name substrings.
- Execute Stored Procedures: In the case of Virtuoso, execute stored procedures and retrieve results.
Tools
podbc_get_schemas
List database schemas accessible to connected database management system (DBMS).
podbc_get_tables
List tables associated with a selected database schema.
podbc_describe_table
Provide the description of a table associated with a designated database schema.
podbc_filter_table_names
List tables, based on a substring pattern from the
qinput field, associated with a selected database schema.podbc_query_database
Execute a SQL query and return results in JSONL format.
