Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DB_HOST | No | The Firebird database host | localhost |
| DB_PORT | No | The Firebird database port | 3050 |
| DB_USER | No | The Firebird database user | SYSDBA |
| SSE_PORT | No | Port for SSE transport | 3003 |
| LOG_LEVEL | No | Logging level (e.g., debug, info, warn, error) | info |
| CORS_ORIGIN | No | Allowed CORS origins (comma-separated) | |
| DB_DATABASE | Yes | Path to the Firebird database file (e.g., /path/to/database.fdb) | |
| DB_PASSWORD | No | The Firebird database password | |
| CORS_HEADERS | No | Allowed CORS headers (comma-separated) | |
| CORS_METHODS | No | Allowed CORS methods (comma-separated) | |
| MAX_SESSIONS | No | Maximum concurrent sessions | 1000 |
| TRANSPORT_TYPE | No | Transport protocol type (stdio, sse, http, or unified) | stdio |
| SSE_SESSION_TIMEOUT_MS | No | Session timeout in milliseconds for SSE transport | 1800000 |
| SESSION_CLEANUP_INTERVAL_MS | No | Session cleanup interval in milliseconds | 60000 |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| execute-query | Executes a SQL query in the Firebird database. Uses FIRST/ROWS for pagination. |
| list-tables | Lists all user tables in the current Firebird database. |
| describe-table | Gets the detailed schema (columns, types, etc.) of a specific table. |
| get-field-descriptions | Gets the stored descriptions for fields of a specific table (if they exist). |
| analyze-query-performance | Analyzes the performance of a SQL query by executing it multiple times and measuring execution time |
| get-execution-plan | Gets the execution plan for a SQL query to understand how the database will execute it |
| analyze-missing-indexes | Analyzes a SQL query to identify missing indexes that could improve performance |
| backup-database | Creates a backup of the Firebird database |
| restore-database | Restores a Firebird database from a backup |
| validate-database | Validates the integrity of the Firebird database |
| execute-batch-queries | Executes multiple SQL queries in parallel for improved performance. |
| describe-batch-tables | Gets the detailed schema of multiple tables in parallel for improved performance. |
| get-server-info | Obtiene información sobre el servidor MCP Firebird y las herramientas disponibles |
| list-available-tools | Lista todas las herramientas disponibles en el servidor MCP |
| get-tool-help | Obtiene información detallada sobre una herramienta específica |
| system-health-check | Verifica el estado de salud del sistema y la conectividad de la base de datos |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
| analyze-table | Analyzes the structure of a specific table and returns its schema. |
| list-tables | Lists all available tables in the database. |
| analyze-table-relationships | Analyzes the relationships of a specific table with other tables. |
| database-schema-overview | Provides an overview of the database schema including tables and their relationships. |
| analyze-table-data | Analyzes the data in a specific table and provides statistics. |
| query-data | Executes and analyzes a SQL query in Firebird |
| optimize-query | Analyzes and suggests optimizations for a SQL query in Firebird |
| generate-sql | Generates a SQL query for Firebird based on a description |
| explain-sql | Explains a SQL query in detail, including its execution plan |
| sql-tutorial | Provides a tutorial on a specific SQL concept with Firebird examples |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |