Available Tools in MCP Firebird

MCP Firebird provides several tools for interacting with Firebird databases. These tools are available through the MCP protocol.

Query Tools

1. execute-query

Executes a SQL query in the Firebird database.

{
  "sql": "SELECT * FROM EMPLOYEES WHERE DEPARTMENT_ID = ?",
  "params": [10]
}

2. list-tables

Lists all user tables in the current database.

{}

3. describe-table

Gets the detailed schema (columns, types, etc.) of a specific table.

{
  "tableName": "EMPLOYEES"
}

4. get-field-descriptions

Gets the stored descriptions for fields of a specific table (if they exist).

{
  "tableName": "EMPLOYEES"
}

5. execute-batch-queries

Executes multiple SQL queries in parallel for improved performance.

{
  "queries": [
    {
      "sql": "SELECT * FROM EMPLOYEES WHERE DEPARTMENT_ID = ?",
      "params": [10]
    },
    {
      "sql": "SELECT * FROM DEPARTMENTS WHERE LOCATION_ID = ?",
      "params": [1700]
    },
    {
      "sql": "SELECT COUNT(*) FROM JOB_HISTORY"
    }
  ],
  "maxConcurrent": 3  // Maximum number of concurrent queries (default: 5, max: 10)
}

6. describe-batch-tables

Gets the detailed schema of multiple tables in parallel for improved performance.

{
  "tableNames": ["EMPLOYEES", "DEPARTMENTS", "JOB_HISTORY"],
  "maxConcurrent": 3  // Maximum number of concurrent operations (default: 5, max: 10)
}

Analysis Tools

7. analyze-query-performance

Analyzes the performance of a SQL query by executing it multiple times and measuring execution time.

{
  "sql": "SELECT * FROM EMPLOYEES WHERE DEPARTMENT_ID = ?",
  "params": [10],
  "iterations": 5
}

8. get-execution-plan

Gets the execution plan for a SQL query to understand how the database will execute it.

{
  "sql": "SELECT * FROM EMPLOYEES WHERE DEPARTMENT_ID = ?"
}

9. analyze-missing-indexes

Analyzes a SQL query to identify missing indexes that could improve performance.

{
  "sql": "SELECT * FROM EMPLOYEES WHERE LAST_NAME = 'Smith'"
}

Database Management Tools

10. backup-database

Creates a backup of the Firebird database.

{
  "backupPath": "C:\\backups\\mydb_backup.fbk",
  "options": {
    "format": "gbak",  // "gbak" (full backup) or "nbackup" (incremental)
    "compress": true,  // Whether to compress the backup
    "metadata_only": false,  // Whether to backup only metadata (no data)
    "verbose": true  // Whether to show detailed progress
  }
}

11. restore-database

Restores a Firebird database from a backup.

{
  "backupPath": "C:\\backups\\mydb_backup.fbk",
  "targetPath": "C:\\databases\\restored_db.fdb",
  "options": {
    "replace": true,  // Whether to replace the target database if it exists
    "pageSize": 8192,  // Page size for the restored database
    "verbose": true  // Whether to show detailed progress
  }
}

12. validate-database

Validates the integrity of the Firebird database.

{
  "options": {
    "checkData": true,  // Whether to validate data integrity
    "checkIndexes": true,  // Whether to validate indexes
    "fixErrors": false,  // Whether to attempt to fix errors
    "verbose": true  // Whether to show detailed progress
  }
}

Proactive Event Tools

13. subscribe_to_event

Subscribes the current connection to a Firebird POST_EVENT trigger. (Requires Streamable HTTP/SSE transport and the native Firebird driver).

{
  "eventName": "NEW_ORDER"
}

Utility Tools

14. ping

Tests connectivity to the MCP Firebird server.

{}

15. echo

Echoes back the input message.

{
  "message": "Hello, Firebird!"
}

16. get-methods

Returns a description of all available MCP tools.

{}

17. describe-method

Returns a description of a specific MCP tool.

{
  "name": "execute-query"
}