Executes a SQL query in the Firebird database. Uses FIRST/ROWS for pagination.

Lists all user tables in the current Firebird database.

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

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

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

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

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

Executes multiple SQL queries in parallel for improved performance.

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

Retrieves data from a specific table with optional filtering, pagination, and ordering.

Analyzes statistical information about a table including row count, column statistics, and data distribution.

Verifies if the current database connection is using wire encryption (requires native driver).

Retrieves general information about the connected Firebird database.

Gets information about the Firebird MCP server and its available tools

Lists all tools available on the MCP server

Gets detailed information about a specific tool

Checks system health and database connectivity

Lists native events (POST_EVENT) available in database triggers and procedures

Lists all database triggers with their associated table, trigger type, and status

Gets detailed information about a specific trigger, including its source code, type, sequence, and status

Lists all stored procedures in the database with input and output parameter information

Gets detailed information about a specific stored procedure, including its source code and parameters

Lists all functions in the database (UDFs and PSQL functions)

Gets detailed information about a specific function, including its source code (for PSQL functions)

Lists all packages in the database (available in Firebird 3.0+)

Gets detailed information about a specific package, including its header and body source

Subscribe to a Firebird event (POST_EVENT) to receive proactive notifications