db-mcp-server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DB_URL | No | MongoDB connection URL (e.g., mongodb://...). Required for MongoDB. | |
| DB_HOST | No | Database host (MySQL/PostgreSQL). | localhost |
| DB_MODE | No | Database access mode. | read-only |
| DB_PATH | No | Path to SQLite database file. Required for SQLite. | |
| DB_PORT | No | Database port (MySQL/PostgreSQL). | 3306 for MySQL, 5432 for PostgreSQL |
| DB_TYPE | No | Database type. Must be 'mysql', 'postgresql', 'mongodb', or 'sqlite'. | |
| DB_USER | No | Database user (MySQL/PostgreSQL). | root for MySQL, postgres for PostgreSQL |
| SSH_KEY | No | Path to SSH private key (e.g., ~/.ssh/id_rsa). | |
| SSH_HOST | No | SSH bastion host. Activates SSH tunnel (not supported for MongoDB). | |
| SSH_PORT | No | SSH port. | 22 |
| SSH_USER | No | SSH username. Defaults to current OS user. | |
| DB_DATABASE | No | Database name. | |
| DB_PASSWORD | No | Database password (required for MySQL and PostgreSQL). | |
| SSH_PASSWORD | No | SSH password (used if no key provided). |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {
"listChanged": false
} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| queryA | Execute a read-only query on the SQLite database. Only SELECT, SHOW, DESCRIBE, EXPLAIN, WITH are allowed on read-only databases. |
| executeB | Execute a write query on the SQLite database. Only works if the database is configured with mode='read-write'. |
| describeA | Describe the structure of a SQLite table (PRAGMA table_info). |
| list_tablesA | List all tables in the SQLite database. |
| statusA | Show connection info: type, host, database, mode, status. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 5 tools
Each tool has a clear and distinct purpose: describe for table structure, execute for write queries, list_tables for listing tables, query for read queries, and status for connection info. No overlap.
All tool names are lowercase, use verbs or verb phrases consistently, and follow a simple pattern (e.g., describe, list_tables). No mixing of conventions.
With 5 tools, the server provides a focused yet complete set for basic SQLite database operations: schema inspection, read/write queries, and status checks. The count feels appropriate for its scope.
The tool set covers essential CRUD operations via generic query and execute tools, but lacks specialized tools for common DDL operations like creating tables. This gap is minor given the generic SQL approach.