MCP Alchemy
JSON →Explore, query, and analyze SQLAlchemy-compatible databases directly from your desktop.
Install
pip install psycopg2-binary Tools · 4
- 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.
Links
★ 404 GitHub stars