MCP Firebird
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 |
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": true
} |
| prompts | {
"listChanged": true
} |
| resources | {
"subscribe": true,
"listChanged": true
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| execute-queryC | Executes a SQL query in the Firebird database. Uses FIRST/ROWS for pagination. |
| list-tablesA | Lists all user tables in the current Firebird database. |
| describe-tableA | Gets the detailed schema (columns, types, etc.) of a specific table. |
| get-field-descriptionsB | Gets the stored descriptions for fields of a specific table (if they exist). |
| get-table-indexesA | Returns all indexes for a table, including ordered columns, uniqueness, direction, and segment count. |
| get-table-constraintsA | Returns PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, and CHECK constraints for a table, including constrained columns and references. |
| get-table-triggersA | Returns only the triggers associated with a table, including source, description, sequence, type, and active state. |
| analyze-query-performanceB | Analyzes the performance of a SQL query by executing it multiple times and measuring execution time |
| get-execution-planA | Prepares an authorized SELECT in a read-only transaction and retrieves its optimizer plan without executing it. Parameters are not bound; unavailable plans return an error, never an execution fallback. |
| analyze-missing-indexesA | Suggests indexes for simple single-table SELECT predicates/order terms after checking existing catalog indexes, including primary keys. Heuristic advice only; never executes the query or applies index DDL. |
| execute-batch-queriesB | Executes multiple SQL queries in parallel for improved performance. |
| describe-batch-tablesA | Gets the detailed schema of multiple tables in parallel for improved performance. |
| get-table-dataB | Retrieves data from a specific table with optional filtering, pagination, and ordering. |
| analyze-table-statisticsB | Analyzes statistical information about a table including row count, column statistics, and data distribution. |
| verify-wire-encryptionA | Reports wire-encryption configuration; does not verify negotiated encryption on an active database connection. |
| get-database-infoC | Retrieves general information about the connected Firebird database. |
| get-server-infoB | Gets information about the Firebird MCP server and its available tools |
| list-available-toolsC | Lists all tools available on the MCP server |
| get-tool-helpC | Gets detailed information about a specific tool |
| system-health-checkA | Reports process health and runtime information; does not probe database connectivity |
| list-available-eventsB | Lists native events (POST_EVENT) available in database triggers and procedures |
| list-triggersB | Lists all database triggers with their associated table, trigger type, and status |
| describe-triggerA | Gets detailed information about a specific trigger, including its source code, type, sequence, and status |
| list-proceduresA | Lists all stored procedures in the database with input and output parameter information |
| describe-procedureA | Gets detailed information about a specific stored procedure, including its source code and parameters |
| list-functionsA | Lists all functions in the database (UDFs and PSQL functions) |
| describe-functionA | Gets detailed information about a specific function, including its source code (for PSQL functions) |
| list-packagesA | Lists all packages in the database (available in Firebird 3.0+) |
| describe-packageA | Gets detailed information about a specific package, including its header and body source |
| echoC | Echoes back the input message |
| subscribe_to_eventB | Register a Firebird POST_EVENT listener; MCP resource subscription is also required for notifications |
| unsubscribe_from_eventA | Release a Firebird event registration owned by this connection or HTTP application |
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 |
|---|---|
| database-tables | Resource representing the list of all tables in the database. |
| database-schema | Resource representing the complete database schema with all tables and their relationships. |
| database-statistics | Resource representing general database statistics. |
TDQS
Scored across 32 tools
Most tools target a clear resource+action (describe-table vs list-tables vs get-table-data). A few boundaries blur: get-server-info advertises 'its available tools' overlapping list-available-tools, and three trigger tools (list-triggers, get-table-triggers, describe-trigger) require careful reading to distinguish.
Nearly all tools follow a predictable kebab-case verb_noun pattern (get-table-indexes, describe-table, list-procedures). Minor deviations: subscribe_to_event/unsubscribe_from_event use snake_case, and system-health-check/echo break the verb_noun shape.
32 tools is on the heavy side, though the broad Firebird object surface (tables, procedures, triggers, functions, packages, events) justifies many. Redundancies like echo and the server-info/list-tools overlap make the set feel padded beyond what the domain strictly needs.
Strong read/describe coverage across tables, procedures, triggers, functions, packages, and events, plus query execution and analysis. Gaps remain for other Firebird objects (views, domains, generators/sequences, exceptions) and any DDL lifecycle, but core exploration workflows are well covered.