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 |
Capabilities
Server capabilities have not been inspected yet.
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-table-data | Retrieves data from a specific table with optional filtering, pagination, and ordering. |
| analyze-table-statistics | Analyzes statistical information about a table including row count, column statistics, and data distribution. |
| verify-wire-encryption | Verifies if the current database connection is using wire encryption (requires native driver). |
| get-database-info | Retrieves general information about the connected Firebird database. |
| 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 |
|---|---|
| database-health-check | Provides a comprehensive guide for analyzing database health, including performance, integrity, and security checks. |
| query-optimization-guide | Provides a step-by-step guide for optimizing SQL queries in Firebird. |
| schema-design-review | Provides a comprehensive guide for reviewing database schema design and suggesting improvements. |
| migration-planning | Provides a comprehensive guide for planning database migrations, schema changes, and data transformations. |
| security-audit | Provides a comprehensive guide for conducting a security audit of the Firebird database. |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |