MCP Alchemy

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
DB_URLYesSQLAlchemy database URL (required). Examples: PostgreSQL: postgresql://user:password@localhost/dbname, MySQL: mysql+pymysql://user:password@localhost/dbname, MariaDB: mariadb+pymysql://user:password@localhost/dbname, SQLite: sqlite:///path/to/database.db
CLAUDE_LOCAL_FILES_PATHNoDirectory for full result sets (optional)
EXECUTE_QUERY_MAX_CHARSNoMaximum output length (optional, default 4000)4000

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription

No tools