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 |
| echoB | Echoes the original message in structured data with markup-encoded display text |
| 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 clearly distinct resources and actions, especially the table, trigger, procedure, function, package, and query-analysis families. There is some overlap among meta/introspection tools such as get-server-info vs list-available-tools, and between list-triggers, get-table-triggers, and describe-trigger, but descriptions generally make the intended use clear.
Most tool names follow a predictable kebab-case verb_noun pattern such as list-tables, describe-table, get-table-indexes, and execute-query. The main deviations are subscribe_to_event and unsubscribe_from_event using snake_case, plus a few noun-only names like echo, but the overall convention remains readable and mostly consistent.
With 32 tools, the server is well above the typical well-scoped range and includes several niche or overlapping meta tools such as list-available-tools, get-server-info, system-health-check, and batch variants. The breadth reflects a comprehensive Firebird surface, but the count feels heavy rather than tightly curated.
Core Firebird workflows are well covered: tables, schemas, data access, indexes, constraints, triggers, procedures, functions, packages, query execution, plans, performance analysis, events, and database/server metadata. Some object categories such as views, generators/sequences, and privileges lack dedicated list/describe tools, though agents can query system tables via execute-query as a workaround.