mcp-sqlalchemy-server
The project is a lightweight MCP server designed for ODBC connections, utilizing FastAPI, pyodbc, and SQLAlchemy. It provides a variety of features for managing and querying databases, including support for Virtuoso DBMS and functionality to execute SQL and SPARQL queries with results in structured formats.
What is the primary use of the MCP Server ODBC via SQLAlchemy?
The server is primarily used for interacting with databases using the Model Context Protocol, supporting schema and table retrieval, query execution, and stored procedure handling.
Which databases are compatible with this server?
The server is compatible with Virtuoso DBMS and other databases that implement a SQLAlchemy provider.
What query result formats are supported?
The server supports JSONL and Markdown table formats for query results.
Can the server execute SPARQL queries?
Yes, the server can execute SPARQL queries, particularly in Virtuoso DBMS.
How can I troubleshoot server interactions?
You can install the MCP Inspector and use it to troubleshoot server interactions by starting the inspector with the appropriate command.