Firebird MCP Server
io.github.lucasgabriel0802/firebird-mcp·v0.1.0Firebird (2.5 to 5.0) MCP server with PLAN inspection and multi-database routing
0 stars35 downloads/wk
Reviews
Write oneNobody has reviewed Firebird MCP Server yet.
If you have run it, two minutes of your experience saves the next person an afternoon.
Firebird MCP Server tools (15, 3 write)
write = sends, deletes, buys or postsRead from the package source without running it. The installed server may list more.
fb_configure_databaseCadastra ou atualiza um banco de dados dinamicamente no catálogo (global ou local). Permite associar o banco a projetos específicos (projects=['web_projects']) e tags para filtragem contextual.
fb_create_configwrite actionCria e salva um novo arquivo de configuração (Catálogo Central Global ~/.firebird-mcp.json por padrão). Permite associar o banco a projetos específicos (ex: projects=['web_projects']) e tags.
fb_database_healthDiagnostica a integridade e telemetria do banco Firebird através das tabelas MON$: - Versão do Engine e ODS - Tamanho de página (Page Size) e sweep interval - Diagnóstico do gap OAT (Oldest Active Transaction) vs Next Transaction para prevenção de inchaço do .fdb - Total de conexões ativas, transações e statements abertos. Se houver múltiplos bancos no projeto e nenhum estiver ativo na sessão, per
fb_execute_ddlwrite actionExecuta comandos estruturais DDL no Firebird (CREATE, ALTER, DROP, RECREATE, etc.) com commit explícito.
fb_execute_dmlwrite actionExecuta comandos de manipulação de dados (INSERT, UPDATE, DELETE, EXECUTE PROCEDURE).
fb_explain_planCompila uma consulta SQL no Firebird e extrai o plano de execução compilado (PLAN). Analisa leituras sequenciais (NATURAL SCAN) em tabelas, ordenações em memória (SORT) e fornece recomendações cirúrgicas de indexação e reescrita. Se houver múltiplos bancos no projeto e nenhum estiver ativo na sessão, pergunte antes ao usuário.
fb_inspect_tableInspeciona detalhadamente a estrutura de uma tabela no Firebird: - Colunas, tipos exatos (DECFLOAT, INT128, BOOLEAN, VARCHAR, BLOB SUB_TYPE), domínios e nullability - Chaves primárias (PK) e estrangeiras (FK) - Índices com ordem (ASC/DESC), colunas participantes e taxa de seletividade real (RDB$STATISTICS). Se houver múltiplos bancos no projeto e nenhum estiver ativo na sessão, pergunte antes ao u
fb_list_databasesLista todos os bancos de dados Firebird configurados no Catálogo Central Global (~/.firebird-mcp.json) ou arquivo local, identificando os bancos correspondentes ao projeto ativo. Informa se há necessidade de confirmação/pergunta ao usuário quando houver múltiplos bancos no projeto.
fb_list_generatorsLista todos os Generators / Sequences de usuário no banco especificado (ou ativo na sessão). Se houver múltiplos bancos no projeto e nenhum estiver ativo na sessão, pergunte antes ao usuário.
fb_list_proceduresLista todas as Stored Procedures cadastradas no banco especificado (ou ativo na sessão). Se houver múltiplos bancos no projeto e nenhum estiver ativo na sessão, pergunte antes ao usuário.
fb_list_tablesLista todas as tabelas de usuário (não de sistema) do banco especificado (ou ativo na sessão). Se houver múltiplos bancos no projeto e nenhum estiver ativo na sessão, pergunte antes ao usuário.
fb_list_viewsLista todas as views de usuário do banco especificado (ou ativo na sessão). Se houver múltiplos bancos no projeto e nenhum estiver ativo na sessão, pergunte antes ao usuário.
fb_queryExecuta consulta SELECT de leitura no Firebird com limite seguro de linhas (1 a 1000). Seguro: Rejeita comandos de alteração de dados e encerra a transação com commit imediato. Se houver múltiplos bancos no projeto e nenhum estiver ativo na sessão, pergunte antes ao usuário.
fb_reload_configRecarrega a configuração de bancos a partir do Catálogo Central Global (~/.firebird-mcp.json) ou arquivo local do projeto.
fb_use_databaseDefine o banco de dados ativo da sessão entre os configurados no catálogo. Suporta busca inteligente por nome exato, case-insensitive, substring no alias ou tag (ex: 'auditoria' -> 'erp_auditoria'). Todas as chamadas seguintes que não especificarem 'db_alias' utilizarão este banco ativo.
Public scan report
scanner v0.1.10 · 2026-10-29 · same rubric, same numbers if you re-run it
- Code scan7 source files scanned25/25
- –Live reliabilityno gateway calls yet and no remote to proben/a
- –Tool poisoningtools not inspected (local package is not executed); not countedn/a
- Auth qualitylocal package, no credentials required12/15
- Maintenancelast push 9 days ago15/15
- Maintainer identityregistry namespace matches repository owner; GitHub account older than a year8/10
How Firebird MCP Server compares
Against every graded Databases MCP server, from our own scans and uptime checks. Updated after each scan run.
- Safety score
- 92/100
- higher than 90% of 802 Databases servers
- Tools
- 15
- the typical Databases server has 8
- Tools that change things
- 20%
- typical: 10%. Fewer write tools means less an agent can break
- Downloads a week
- 35
- more than 21% of 328 Databases servers with a package
What its tools let an agent do: 12 read · 3 change
Install Firebird MCP Server in Claude Code, Cursor or VS Code
claude mcp add firebird-mcp -- uvx firebird-mcp
What the publisher says
From the Firebird MCP Server repository's README, as published. We do not edit it. Read it on GitHub
Firebird MCP Server 🔥
🌐 Language / Idioma: English | Português (Brasil)
Open-source Model Context Protocol (MCP) server for Firebird Database, developed for free and independent community use with support for all major releases (Firebird 2.5, 3.0, 4.0, and 5.0).
Built according to the open industry standards for MCP servers (stdio / JSON-RPC 2.0), ensuring turnkey compatibility with any AI client or IDE: Google Antigravity IDE, Cursor, Claude Desktop, VS Code (with Cline / Roo Code / Copilot extensions), Windsurf, Zed, and CLI tools.
🎯 Key Highlights
- Pure Python Wire Protocol (Zero DLL Dependencies):
- Connects directly over TCP (default port 3050) using pure Python (firebirdsql).
- Requires no native C/C++ compilation and eliminates the need to install fbclient.dll (Windows) or libfbclient.so (Linux) on the host running the AI client or IDE.
- Fully compatible with legacy authentication (Legacy_Auth in FB 2.5) as well as modern pluggable SRP authentication in FB 3.0, 4.0, and 5.0.
- Multi-Database Support per Project:
- Allows a single project workspace to declare and manage multiple databases (e.g., main, audit_logs, staging), switching dynamically via chat prompts or tool arguments.
- Workspace Auto-Discovery (.firebird-mcp.json):
- Automatically detects database configuration files placed at the root of your project or repository.
- Execution Plan & Performance Analysis (PLAN):
- Compiles queries to extract the Firebird optimizer's execution plan (PLAN) without scanning entire datasets, detecting unindexed full-table scans (NATURAL SCAN) and memory/disk sorting bottlenecks (SORT).
- Strict Query Safety & MVCC Best Practices:
- fb_query enforces read-only operations (SELECT), guarding against accidental data modification.
- Commits read transactions immediately upon completion, preventing OAT (Oldest Active Transaction) stalls, garbage collection starvation, and runaway .fdb database file growth.
- Broad System Catalog Mapping:
- Comprehensive introspection of Firebird system catalog tables (RDB$), supporting types across versions: BOOLEAN (FB3+), INT128, DECFLOAT(16/34), TIMESTAMP WITH TIME ZONE (FB4+), BLOB SUB_TYPE TEXT/BINARY, and index selectivity (RDB$STATISTICS).
🗄️ Multi-Database & Per-Project Configuration
Real-world production codebases (such as enterprise ERPs in Delphi, Laravel, or Python) frequently require:
- Different databases per project/workspace.
- Multiple databases within the same project (e.g., operational database ERPDATA.FDB and audit trail AUDITLOGS.FDB).
Where and How to Configure Databases:
Firebird MCP provides two flexible organization patterns:
Option A (Recommended Default): Central Global Catalog (~/.firebird-mcp.json)
Instead of scattering .firebird-mcp.json files across every repository, maintain a single central catalog in your user home directory (~/.firebird-mcp.json on Linux/macOS or C:\Users\YourUser\.firebird-mcp.json on Windows).
In this catalog, you register all databases on your machine and use the "projects" property to specify which projects/repositories use each database:
Shortened. The full README is on GitHub.
Nothing above is checked by us. What we check is on the safety report.
Firebird MCP Server: common questions
- Is Firebird MCP Server safe?
- Yes, by our scan: it is graded A (92/100). Read the Firebird MCP Server safety report
- How do I install Firebird MCP Server?
- It runs on your machine. Copy the Claude Code, Cursor, VS Code or Claude Desktop config from the install section.
- Does Firebird MCP Server need an API key?
- No secret keys are declared. It reads 1 setting from the environment.
- Is Firebird MCP Server maintained?
- The last commit was 15 days ago (2026-10-19). The latest release is v0.1.0.
- What can I use instead of Firebird MCP Server?
- Servers from other publishers that do the same job: ArcadeDB MCP Server, ArcadeDB MCP server and Homespun MCP server.
- How does Firebird MCP Server compare with other Databases MCP servers?
- safety score 92/100 (higher than 90% of 802 Databases servers); tools 15 (the typical Databases server has 8); tools that change things 20% (typical: 10%. Fewer write tools means less an agent can break). Full comparison.
Alternatives to Firebird MCP Server
Same job from other publishers: the closest match first, then the best rated.
ArcadeDB MCP ServerBuilt-in MCP server for ArcadeDB multi-model database (graph, document, vector, time-series)not reviewedGrowingB- ArcadeDBMulti-Model database with built-in MCP server for SQL, Cypher, Gremlin, and GraphQL.not reviewedGrowingB
- HomespunDeploy a multi-user web app from your agent: hosting, auth, database, and permissions.not reviewedGrowingB
- CogniCoreMemory, reflection and safety for AI agents. Hosted or local, no vector database.5.0(1)GrowingA
- DBHubToken-efficient database MCP server for PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, SQLitenot reviewedWidely usedA