Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
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 |
|---|---|
No resources | |
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 |