AI Atlas

Database · Developer Tools

SQLAlchemy ODBC Bridge logo

SQLAlchemy ODBC Bridge

openlinksoftware/mcp-sqlalchemy-server

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.

View on GitHub9

Install

Client configuration

{
  "mcpServers": {
    "my_database": {
      "command": "uv",
      "args": [
        "--directory",
        "/path/to/mcp-sqlalchemy-server",
        "run",
        "mcp-sqlalchemy-server"
      ],
      "env": {
        "ODBC_DSN": "<ODBC_DSN>",
        "ODBC_USER": "<ODBC_USER>",
        "ODBC_PASSWORD": "<ODBC_PASSWORD>",
        "API_KEY": "<API_KEY>"
      }
    }
  }
}

Environment variables

ODBC_DSNODBC_USERODBC_PASSWORDAPI_KEY
GitHub stars
9
Author
@openlinksoftware
Category
Database, Developer Tools
Updated
Oct 6, 2026

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:

  • Search Tables: Filter and retrieve tables based on name substrings.

  • Execute Stored Procedures: In the case of Virtuoso, execute stored procedures and retrieve results.

  • Execute Queries:

Tools (12)

  • 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 q input field, associated with a selected database schema.

  • podbc_query_database

    Execute a SQL query and return results in JSONL format.

  • podbc_execute_query

    Execute a SQL query and return results in JSONL format.

  • podbc_execute_query_md

    Execute a SQL query and return results in Markdown table format.

  • podbc_spasql_query

    Execute a SPASQL query and return results.

  • podbc_sparql_query

    Execute a SPARQL query and return results.

  • podbc_virtuoso_support_ai

    Interact with the Virtuoso Support Assistant/Agent -- a Virtuoso-specific feature for interacting with LLMs

  • podbc_query_database_md

  • podbc_query_database_jsonl

Details on this page are taken from the project's README. Open README

Supported clients

Clients mentioned in this server's README:

View all
Claude Desktop logo

Claude Desktop

Desktop · Freemium · Proprietary

Anthropic's official Claude AI desktop application. Supports MCP servers to extend functionality.

WindowsMacOS

Related MCP servers

More servers
Supabase MCP logo

Supabase MCP

supabase-community/supabase-mcp

1.3k

The Model Context Protocol (MCP) standardizes how Large Language Models (LLMs) talk to external services like Supabase. It connects AI assistants directly with your Supabase project and allows them to perform tasks like managing tables, fetching config, and querying data. See the full list of tools.

Database
Genai Toolbox logo

Genai Toolbox

googleapis/genai-toolbox

769

MCP Toolbox for Databases is an open source Model Context Protocol (MCP) server that connects your AI agents, IDEs, and applications directly to your enterprise databases.

Database
Supabase MCP Server logo

Supabase MCP Server

alexander-zuev/supabase-mcp-server

677

Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.

Database
Awesome MCP List logo

Awesome MCP List

MobinX/awesome-mcp-list

645

This is a continuously updated curated list of MCP servers, covering categories such as browser control, arts and culture, cloud platforms, command line, communication, customer data platforms, databases, developer tools, data science tools, file systems, finance and fintech, gaming, knowledge and memory, location services, marketing, monitoring, search and utilities. Each project includes a GitHub link and star count for quick reference and use.

Database
PostgreSQL Model Context Protocol (PG MCP) Server logo

PostgreSQL Model Context Protocol (PG MCP) Server

stuzero/pg-mcp-server

440

PG-MCP is a server implementation of the Model Context Protocol for PostgreSQL databases. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases through MCP's resource-oriented architecture.

Database
dbhub logo

dbhub

bytebase/dbhub

332

[!NOTE] If you need an enterprise-level database MCP server with built-in guardrails like approval flow, access control, data masking, and audit logging beyond what DBHub offers, check out Bytebase.

Database