MCP Servers / database / MCP Alchemy

MCP Alchemy

JSON →
httpnone404database

Explore, query, and analyze SQLAlchemy-compatible databases directly from your desktop.

Install
How to run this server
[ { "cmd": "pip install psycopg2-binary", "imports": [] } ]
server path: mcp-alchemy
Tools
What this server exposes
all_table_names
Return all table names in the database. No input required. Returns comma-separated list of tables.
filter_table_names
Find tables matching a substring. Input: q (string). Returns matching table names.
schema_definitions
Get detailed schema for specified tables. Input: table_names (string[]). Returns table definitions including column names and types, primary keys, foreign key relationships, and nullable flags.
execute_query
Execute SQL query with vertical output format. Inputs: query (string), params (object, optional). Returns results in clean vertical format with smart truncation, full result set access, clean NULL value display, ISO formatted dates, and clear row separation.
Configuration
Environment & auth
authnone
Resources
MCP Alchemy — MCP Server · libregistry