mcp-sqlalchemy-serverA simple MCP ODBC server using FastAPI, ODBC and SQLAlchemy.

— (0)

Reviewed by Daniel Nikulshyn·Updated July 2026

Overview

A lightweight MCP (Model Context Protocol) server for ODBC built with FastAPI, pyodbc, and SQLAlchemy. This server is compatible with Virtuoso DBMS and other DBMS backends that implement a SQLAlchemy provider. It allows interaction with a database management system (DBMS) through ODBC, providing features such as listing schemas, retrieving table information, describing table structures, searching tables, and executing stored procedures and queries.

Key features

Get Schemas
Get Tables
Describe Table
Search Tables
Execute Stored Procedures
Execute Queries

Pricing

Model: Free
Category: MCP Servers
Rating: No reviews yet

Use cases

Database Schema Exploration

Use the MCP server to list and explore database schemas, tables, and table structures.

Query Execution

Execute SQL queries on a connected DBMS and retrieve results in JSONL or markdown table formats.

Pros & Cons

Pros

Compatible with multiple DBMS backends
Supports listing schemas, tables, and describing table structures
Can execute stored procedures and queries
Provides results in JSONL and markdown table formats

Cons

Requires ODBC setup and configuration
Depends on SQLAlchemy provider for DBMS compatibility

Reviews

No reviews yet. Be the first!

Q&A

What are the main capabilities and typical use cases?

The server lets you list schemas, retrieve table metadata, describe table structures, search tables, and run stored procedures or ad‑hoc SQL queries, returning results as JSONL or markdown tables—ideal for data‑exploration tools, reporting pipelines, or integrating with AI assistants.

Asked by Ludovic Girard · Apr 14, 2026

Do I need to set up ODBC manually before using the server?

Yes, you must install and configure an ODBC driver (e.g., via unixODBC), create a DSN in ~/.odbc.ini, and supply the DSN, user, and password in the .env file before the FastAPI server can connect.

Asked by Dmitri Volkov · Mar 25, 2026

Which databases can I connect to with this server?

It works with any DBMS that has a SQLAlchemy driver and an ODBC driver, such as Virtuoso (tested) and PostgreSQL; you just configure the appropriate ODBC DSN and SQLAlchemy URL.

Asked by Elena Rossi · Mar 24, 2026

What is the cost to use mcp-sqlalchemy-server?

The tool is open‑source and freely available on GitHub, so there are no licensing fees; you only incur any infrastructure costs for hosting the FastAPI service.

Asked by Kalinda Reddy · Jan 24, 2026