Skip to main content
Glama

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
DB_HOSTNoThe Firebird database hostlocalhost
DB_PORTNoThe Firebird database port3050
DB_USERNoThe Firebird database userSYSDBA
SSE_PORTNoPort for SSE transport3003
LOG_LEVELNoLogging level (e.g., debug, info, warn, error)info
CORS_ORIGINNoAllowed CORS origins (comma-separated)
DB_DATABASEYesPath to the Firebird database file (e.g., /path/to/database.fdb)
DB_PASSWORDNoThe Firebird database password
CORS_HEADERSNoAllowed CORS headers (comma-separated)
CORS_METHODSNoAllowed CORS methods (comma-separated)
MAX_SESSIONSNoMaximum concurrent sessions1000
TRANSPORT_TYPENoTransport protocol type (stdio, sse, http, or unified)stdio
SSE_SESSION_TIMEOUT_MSNoSession timeout in milliseconds for SSE transport1800000
SESSION_CLEANUP_INTERVAL_MSNoSession cleanup interval in milliseconds60000

Capabilities

Features and capabilities supported by this server

CapabilityDetails
tools
{
  "listChanged": true
}
prompts
{
  "listChanged": true
}

Tools

Functions exposed to the LLM to take actions

NameDescription
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).

analyze-query-performanceB

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

get-execution-planB

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

analyze-missing-indexesA

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

backup-databaseC

Creates a backup of the Firebird database

restore-databaseC

Restores a Firebird database from a backup

validate-databaseC

Validates the integrity of the Firebird database

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

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

get-database-infoB

Retrieves general information about the connected Firebird database.

get-server-infoA

Obtiene información sobre el servidor MCP Firebird y las herramientas disponibles

list-available-toolsB

Lista todas las herramientas disponibles en el servidor MCP

get-tool-helpC

Obtiene información detallada sobre una herramienta específica

system-health-checkB

Verifica el estado de salud del sistema y la conectividad de la base de datos

Prompts

Interactive templates invoked by user choice

NameDescription
database-health-checkProvides a comprehensive guide for analyzing database health, including performance, integrity, and security checks.
query-optimization-guideProvides a step-by-step guide for optimizing SQL queries in Firebird.
schema-design-reviewProvides a comprehensive guide for reviewing database schema design and suggesting improvements.
migration-planningProvides a comprehensive guide for planning database migrations, schema changes, and data transformations.
security-auditProvides a comprehensive guide for conducting a security audit of the Firebird database.

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/PuroDelphi/mcpFirebird'

If you have feedback or need assistance with the MCP directory API, please join our Discord server