MCP Server ODBC via SQLAlchemy

Created By

MCP-Mirrora year ago

Mirror of

Overview

What is MCP Server ODBC via SQLAlchemy?

MCP Server ODBC via SQLAlchemy is a lightweight server designed for ODBC connections, built using FastAPI, pyodbc, and SQLAlchemy. It is compatible with Virtuoso DBMS and other databases that support SQLAlchemy.

How to use MCP Server ODBC via SQLAlchemy?

To use the MCP server, clone the repository, set up your ODBC Data Source Name (DSN), and configure your environment variables. You can then connect to various databases using the provided connection URLs.

Key features of MCP Server ODBC via SQLAlchemy?

Fetch and list all schema names from the connected database.
Retrieve table information for specific schemas.
Generate detailed descriptions of table structures.
Execute stored procedures and SQL queries with results in JSONL or Markdown formats.

Use cases of MCP Server ODBC via SQLAlchemy?

Managing database schemas and tables.
Executing complex SQL queries and retrieving structured results.
Integrating with various database management systems using a unified interface.

FAQ from MCP Server ODBC via SQLAlchemy?

What databases are supported?

The server supports any DBMS that implements a SQLAlchemy provider, including Virtuoso, PostgreSQL, MySQL, and SQLite.

Is there a specific installation requirement?

Yes, you need to install the uv package and configure your ODBC DSN properly.

Can I execute stored procedures?

Yes, the server allows executing stored procedures, particularly with Virtuoso.

Project Info

Created At

a year ago

Updated At

a year ago

Author Name

MCP-Mirror

Star

Language

Python

License

Apache-2.0 license

Recommend Servers

View All

Aws Kb Retrieval Server

@modelcontextprotocol

An MCP server implementation for retrieving information from the AWS Knowledge Base using the Bedrock Agent Runtime.

a year ago

Tavily Mcp

@tavily-ai

JavaScript

a year ago

Neon MCP Server

@neondatabase-labs

MCP server for interacting with Neon Management API and databases

TypeScript

a year ago

11 days ago

11 days ago

11 days ago

Tanzania Payments Mcp

@junter1989k-ai

11 days ago

Switzerland Payments Mcp

@junter1989k-ai

11 days ago

Portugal Payments Mcp

@junter1989k-ai

11 days ago

Time

@modelcontextprotocol

A Model Context Protocol server that provides time and timezone conversion capabilities. This server enables LLMs to get current time information and perform timezone conversions using IANA timezone names, with automatic system timezone detection.

5 months ago

Oman Payments Mcp

@junter1989k-ai

11 days ago

Bangladesh Payments Mcp

@junter1989k-ai

11 days ago

EdgeOne Pages MCP

@TencentEdgeOne

An MCP service designed for deploying HTML content to EdgeOne Pages and obtaining an accessible public URL.

TypeScript

a year ago

Playwright Mcp

@microsoft

Playwright MCP server

TypeScript

a year ago

Search1API

One API for Search, Crawling, and Sitemaps

a year ago

Howtocook Mcp

@worryzyy

基于Anduin2017 / HowToCook （程序员在家做饭指南）的mcp server，帮你推荐菜谱、规划膳食，解决“今天吃什么“的世纪难题； Based on Anduin2017/HowToCook (Programmer's Guide to Cooking at Home), MCP Server helps you recommend recipes, plan meals, and solve the century old problem of "what to eat today"

a year ago

11 days ago

Query verified 2026 US dental cost data from Real Dental Costs: average implant, veneer, braces and procedure prices for all 50 states and 206 cities, state-vs-state comparisons, and the composite US Dental Cost Index. Open data (CC BY 4.0, Zenodo DOIs). Every response includes the source and a reference URL. Pricing/market research, not medical advice. Data: https://realdentalcosts.com

11 days ago

11 days ago

VC follow intelligence for AI agents. Track what top investors follow on X — detect new follows, convergence signals, and trending companies before they're announced.

5 days ago

AgentQL MCP Server

@tinyfish-io

Model Context Protocol server that integrates AgentQL's data extraction capabilities.

JavaScript

a year ago

11 days ago

A Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.

a year ago

Amap Maps

@amap

高德地图官方 MCP Server

a year ago

Test

@modelcontextprotocol

test

7 months ago

PostgreSQL

@modelcontextprotocol

Read-only database access with schema inspection

a year ago

Redis

@modelcontextprotocol

A Model Context Protocol server that provides access to Redis databases. This server enables LLMs to interact with Redis key-value stores through a set of standardized tools.

a year ago

PAPI

@getpapi

Persistent Adaptive Planning Intelligence - structured loop engineering for AI coding assistants, with memory that persists across sessions, tools, and teammates.

11 days ago

Google Maps

@modelcontextprotocol

Location services, directions, and place details

a year ago

Puppeteer

@modelcontextprotocol

Browser automation and web scraping

a year ago