Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| LOG_LEVEL | No | Logging level for debugging (e.g., debug) | |
| FIREBIRD_HOST | No | The hostname of the Firebird database server | localhost |
| FIREBIRD_PORT | No | The port number of the Firebird database server | 3050 |
| FIREBIRD_ROLE | No | Optional database role | |
| FIREBIRD_USER | No | Username for connecting to the Firebird database | SYSDBA |
| FIREBIRD_DATABASE | No | Path to the Firebird database file (.fdb) | |
| FIREBIRD_PASSWORD | No | Password for connecting to the Firebird database | masterkey |
| FIREBIRD_DATABASE_DIR | No | Directory containing multiple Firebird databases |
Schema
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 |
|---|---|
| Resource: /tables | |
| Resource: /tables/{tableName}/schema | |
| Resource: /tables/{tableName}/description | |
| Resource: /tables/{tableName}/data |
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 |
| get-methods | Returns a description of all available MCP tools (methods) |
| describe-method | Returns a description of a specific MCP tool (method) |
| ping | Tests connectivity to the Firebird MCP server |
| echo | Echoes back the input message |