convez.ai
MCP ServerDados & AnalyticsIntermediário
Michael2150

FlameRobin MCP Server

Michael2150/flamerobin-mcp-server

Acesso integrado a Firebird via FlameRobin, sem configuração

Ver no GitHub
InicialPluginScore · de 0 a 100

Servidor MCP para Firebird que integra-se automaticamente com FlameRobin, lendo credenciais do arquivo `fr_databases.conf` sem necessidade de configuração adicional. Oferece introspeccão completa de schema (tabelas, views, procedures, triggers, generators, roles), execução de DDL/DML/scripts e análise de índices faltantes.

Instalação

$npx convez-ai Michael2150/flamerobin-mcp-server

1 comando no terminal: detecta o formato do repositório (marketplace ou plugin avulso) e instala via Claude Code. Requer Node 18+ e o Claude Code instalado.

Métricas

Estrelas
2
Forks
1
Acompanhando
0
Saúde
28%
Último commit
há 5 meses
Versão
v1.0.2
Issues abertas
0
Contribuidores
2

Casos de uso

  • Consultar e analisar schema de bancos Firebird registrados no FlameRobin
  • Executar queries, DDL e scripts SQL contra múltiplos bancos simultaneamente
  • Gerar planos de execução e identificar colunas sem índices
  • Extrair código-fonte de procedures, triggers e views

Veredito

Ferramenta sólida e bem-integrada para quem trabalha com Firebird e FlameRobin localmente, eliminando atrito na configuração. Limitado ao uso local, mas com funcionalidades avançadas de schema introspection que superam alternativas como mcpFirebird.

README

A tradução para o português deste README ainda está na fila.

flamerobin-mcp-server

A Model Context Protocol (MCP) server for Firebird databases intended for local use. It reads connection details from FlameRobin's fr_databases.conf so no extra configuration is needed — if you have FlameRobin set up with your Firebird databases, this server works out of the box.

Compared to mcpFirebird

This projectmcpFirebird
CredentialsRead automatically from FlameRobin's config — no setup requiredMust pass --user, --password, --host, --database on every launch
Multi-databaseAll FlameRobin-registered databases available in one sessionSingle database per server instance
Wire encryptionSupported (native Firebird .NET driver)Not supported — requires WireCrypt = Disabled on the server
Runtime.NET 9 self-contained executableNode.js / npm
Schema introspectionTables, views, procedures, triggers, generators, roles, FK/PK/constraints, execution plans, missing index analysisTables and basic schema
DDL / DML / scriptsYes — ExecuteDdl, ExecuteDml, ExecuteScriptSQL execution only
DeploymentLocal only — runs on your PC alongside FlameRobinCloud-deployable via Smithery, SSE/HTTP transports

Building

dotnet build FirebirdMcp.csproj

Publishing a single self-contained executable

dotnet publish FirebirdMcp.csproj -c Release -r win-x64 --self-contained true -p:PublishSingleFile=true -p:IncludeNativeLibrariesForSelfExtract=true -o publish-single

The output is publish-single\FirebirdMcp.exe. The publish-single\ folder is gitignored.

Claude Desktop configuration

Add to claude_desktop_config.json:

{
  "mcpServers": {
    "firebird": {
      "command": "C:\\path\\to\\publish-single\\FirebirdMcp.exe",
      "env": {
        "Logging__LogLevel__Default": "None"
      }
    }
  }
}

Important: The Logging__LogLevel__Default=None env var is required. The server's startup log output is written to stdout, which Claude reads as part of the MCP handshake — any unexpected output causes Claude to fail to recognize the server.

Tools

ToolDescription
ListDatabasesList all servers/databases registered in FlameRobin
ListObjectsList tables, views, or both — with optional regex filter
ListProceduresList stored procedures — with optional regex filter
ListTriggersList triggers — with optional regex filter
ListGeneratorsList generators/sequences with current values
ListRolesList roles — with optional regex filter
DescribeTableColumn definitions — supports brief mode and column filter
GetForeignKeysFK relationships for a table (in, out, or all directions)
GetTableConstraintsPK, FK, UNIQUE, CHECK constraints for a table
GetProcedureSourcePSQL source of a stored procedure
GetTriggerSourcePSQL source of a trigger
GetViewSourceSQL source of a view
GetExecutionPlanExecution plan for a SELECT — shows index usage
AnalyzeMissingIndexesWhich columns lack indexes; optionally scoped to filter columns
GetDatabaseInfoODS version, page size, dialect, etc.
ListActiveConnectionsActive connections to the database
RunQueryExecute a SELECT — supports maxRows and columns projection
ExecuteDdlExecute CREATE/ALTER/DROP and commit
ExecuteDmlExecute INSERT/UPDATE/DELETE and commit
ExecuteScriptExecute multiple semicolon-separated statements
Ver o original no GitHub

Bom para

Relacionados