MCP SQL Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| MCP_SQL_MAX_ROWS | No | Máximo de filas devueltas por consulta | 200 |
| MCP_SQL_DATABASE_URL | No | URL SQLAlchemy para la conexión a la base de datos | sqlite:///./dev.db |
| MCP_SQL_ALLOW_DESTRUCTIVE_DDL | No | true/false para permitir DROP y TRUNCATE | false |
| MCP_SQL_MAX_SCRIPT_STATEMENTS | No | Máximo de sentencias por script | 100 |
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 |
|---|---|
| sql_capabilitiesB | Describe la configuración activa y operaciones soportadas. |
| sql_list_tablesB | Lista tablas y vistas disponibles en el esquema actual. |
| sql_describe_tableB | Describe columnas, PK, FK e índices de una tabla. |
| sql_runB | Ejecuta una sentencia SQL individual usando parámetros nombrados opcionales. |
| sql_run_scriptA | Ejecuta múltiples sentencias SQL en secuencia; se detiene al primer error. |
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 clearly distinct purpose: sql_capabilities provides metadata about the server, sql_describe_table describes a specific table's structure, sql_list_tables enumerates available tables/views, sql_run executes a single SQL statement, and sql_run_script handles multiple statements. There is no overlap or ambiguity between these functions.
All tool names follow a consistent snake_case pattern with a 'sql_' prefix and descriptive verb_noun combinations (e.g., sql_list_tables, sql_run_script). This uniformity makes the tool set predictable and easy to understand.
With 5 tools, the server is well-scoped for SQL operations. Each tool serves a specific, essential function in a database interaction workflow, from discovery (list_tables, describe_table) to execution (run, run_script), and configuration (capabilities). No tool feels redundant or missing.
The tool set covers core SQL operations effectively: listing and describing tables, running queries and scripts, and checking server capabilities. A minor gap is the lack of tools for schema modification (e.g., create/alter/drop tables) or transaction management, but agents can work around this using sql_run for such operations.