Schema | simple-db-mcp

simple-db-mcp

Describes the environment variables required to run the server.

Name	Required	Description	Default
`SIMPLE_DB_MCP_MAX_ROWS`	No	Maximum number of rows returned by execute_query.	100
`SIMPLE_DB_MCP_READ_ONLY`	No	Whether to enable read-only mode (true/false).	true
`SIMPLE_DB_MCP_CONFIG_FILE`	No	Path to a TOML configuration file for one or more named databases.
`SIMPLE_DB_MCP_DATABASE_URL`	No	The SQLAlchemy async database URL for a single database (e.g., postgresql+asyncpg://user:pass@host/db).
`SIMPLE_DB_MCP_QUERY_TIMEOUT_SECONDS`	No	Timeout in seconds for queries.	30

Features and capabilities supported by this server

Capability	Details
`tools`	{ "listChanged": true }
`logging`	{}
`prompts`	{ "listChanged": false }
`resources`	{ "subscribe": false, "listChanged": false }
`extensions`	{ "io.modelcontextprotocol/ui": {} }
`experimental`	{}

Functions exposed to the LLM to take actions

Name	Description
healthA	Return basic server health and non-sensitive configuration.
versionA	Return the server name and version.
ping_databaseB	Verify that the configured database connection works.
list_schemasC	List available database schemas.
list_tablesA	List tables and views in a schema.
describe_tableB	Describe columns and primary key metadata for a table.
execute_queryB	Execute a read-only SQL query with a configured row limit.
explain_queryB	Return the database query plan for a read-only SQL query.

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/torcato/simple-db-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server