mcp-sqlalchemy-server
mcp-sqlalchemy-server is an MCP server. It reaches odbc. It needs ODBC_PASSWORD to authenticate. Its repository has 25 GitHub stars and is licensed under MIT; we last read it on 2026-10-22.
This software provides an MCP ODBC server using FastAPI and SQLAlchemy.
Install
MCP servers are packaged differently from each other -- some run via npx, some as a Docker image, some as a plain script you clone and run. mcp-sqlalchemy-server’s own README did not state one plainly enough for this page to quote it rather than guess, so it will not guess. The repository below states it.
What it reaches, and what it needs
Maintenance
A simple MCP ODBC server using FastAPI, ODBC and SQLAlchemy.
What mcp-sqlalchemy-server can do
10 tools documented in its README. An AI client calls these by name.
podbc_get_schemas- Retrieve and return a list of all schema names from the connected database.
podbc_get_tables- Retrieve and return a list containing information about tables in a specified schema. If no schema is provided, uses the connection's default schema.
podbc_describe_table- Retrieve and return detailed information about the columns of a specific table.
podbc_filter_table_names- Filters and returns information about tables whose names contain a specific substring.
podbc_query_database- Execute a standard SQL query and return the results in JSON format.
podbc_query_database_md- Execute a standard SQL query and return the results formatted as a Markdown table.
podbc_query_database_jsonl- Execute a standard SQL query and return the results in JSON Lines (JSONL) format (one JSON object per line).
podbc_spasql_query- Execute a SPASQL (SQL/SPARQL hybrid) query return results. This is a Virtuoso-specific feature.
podbc_sparql_query- Execute a SPARQL query and return results. This is a Virtuoso-specific feature.
podbc_virtuoso_support_ai- Utilizes a Virtuoso-specific AI Assistant function, passing a prompt and optional API key. This is a Virtuoso-specific feature.
Read from the README; names are kept only if the README contains them.
Common questions about mcp-sqlalchemy-server
- What does mcp-sqlalchemy-server do?
- This software provides an MCP ODBC server using FastAPI and SQLAlchemy.
- How do I install mcp-sqlalchemy-server?
- Its README did not state an install command plainly enough for us to quote one, so we do not guess. The repository has the instructions: https://github.com/OpenLinkSoftware/mcp-sqlalchemy-server
- What does mcp-sqlalchemy-server connect to, and what does it need?
- It reaches odbc. The credentials we found in its source are ODBC_PASSWORD.
- Is mcp-sqlalchemy-server official and is it maintained?
- We found nothing naming it as a vendor’s official server. Its repository has 25 GitHub stars and its state in our directory is stale. Its last commit we recorded was on 2025-05-23.
- What licence does mcp-sqlalchemy-server use?
- The repository declares the MIT licence.