mcp-bd-readonly
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DATA_DIR | No | Directory for data files, including the audit log. | |
| MYSQL_DB | No | MySQL database name. Typically back. | |
| MYSQL_HOST | No | MySQL host. Typically 127.0.0.1. | |
| MYSQL_PORT | No | MySQL port. Typically 13306. | |
| MYSQL_USER | No | MySQL user with read-only access. Typically back_readonly. | |
| TUNNEL_HOST | No | SSH host alias for the auto-tunnel. | optimaback-active |
| MYSQL_PASSWORD | No | Password for the MySQL user. |
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 |
|---|---|
| list_databasesB | Lista las bases de datos disponibles (SHOW DATABASES). |
| list_tablesC | Lista las tablas de un esquema (default 'back'). |
| describe_tableC | Columnas y tipos de una tabla (DESCRIBE). |
| run_queryB | SQL solo-lectura; devuelve {columns, rows} (JSON). limit clamp filas (default 100; 0=sólo conteo, None=todo). |
| facturas_ventaC | Facturas en un rango de fechas (max_n filas, default 200) + total_periodo exacto |
| resumen_ivaC | Base/IVA/Total de un trimestre (anio + trimestre 1-4) |
| remesas_pendientesC | Efectos pendientes (últimos por vencimiento, max_n límite) y total |
| cuadre_facturaC | Comprueba que la suma de líneas == total de cabecera |
| conciliar_remesasC | Total emitido vs acreditado de remesas (pago = fecha_pagado) |
| saldos_clienteC | Facturado vs cobrado y pendiente de un cliente |
| excepcionesC | Facturas sobre umbral clasificadas por materialidad |
| informe_financieroC | Informe Markdown + CSV(;) de un periodo (max_n filas, default 200) |
| setup_sshB | Prepara SSH para el túnel de BD: genera clave ed25519 si falta, añade el host al config, y devuelve la clave pública lista para Forge. |
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 13 tools
Generic DB tools (list_databases, list_tables, describe_table, run_query) are clearly distinct, but several domain-report tools overlap: facturas_venta, excepciones, and informe_financiero all operate on invoices over periods, and cuadre_factura, conciliar_remesas, and saldos_cliente all touch reconciliation/balance concerns. Descriptions help differentiate but boundaries remain fuzzy.
All names use snake_case, which is consistent, but the set mixes English generic verbs (list_databases, run_query, describe_table, setup_ssh) with Spanish noun-phrase domain tools (facturas_venta, resumen_iva, saldos_cliente, excepciones). Verb_noun and bare-noun patterns are intermixed without a clear rule.
13 tools is a reasonable, well-scoped set: four generic DB primitives plus eight domain reports and one setup helper. Nothing feels redundant enough to trim, though setup_ssh sits slightly apart from the read-only query purpose.
The read-only surface covers discovery (databases/tables/columns), ad-hoc querying, and the main financial reporting workflows (invoices, VAT, remittances, reconciliation, balances, exceptions, reports). A generic export or trend/aggregation helper is missing, but run_query provides a solid fallback.