[{"_1":2,"_478":-5,"_479":-5},"loaderData",{"_3":4,"_26":27,"_28":29,"_30":31,"_363":364},"root",{"_5":6,"_14":15},"toasts",[7],{"_8":9,"_10":11,"_12":13},"uid","4da98349-c72b-4b31-980b-205defc86f69","title","This MCP server does not support inspection","type","error","visitor",{"_16":17,"_18":19},"viewportWidth",1280,"visitorSession",{"_20":21,"_23":-5,"_8":24,"_25":-5},"attributes",[22],"BOT","membership","cgG6ESdNWx","userAccount","routes/_public/_layout",{},"routes/_public/mcp/servers/~namespace/_layout",{},"routes/_public/mcp/servers/~namespace/~slug/_pages/_layout",{"_32":-5,"_33":34,"_35":36,"_284":285},"githubUser","maintainer",false,"mcpServer",{"_37":38,"_39":40,"_20":82,"_90":91,"_92":91,"_93":94,"_99":100,"_122":-5,"_123":124,"_125":126,"_127":128,"_109":173,"_174":114,"_175":176,"_180":181,"_209":-5,"_210":211,"_218":219,"_233":234,"_239":-5,"_135":110,"_240":241,"_245":246,"_8":281,"_282":283},"addedAt",["D",1742796211238],"argumentsJsonSchema",{"_41":42,"_52":53,"_12":81},"oneOf",[43,49],{"_44":45},"required",[46,47,48],"FIREBIRD_DATABASE","FIREBIRD_USER","FIREBIRD_PASSWORD",{"_44":50},[51,47,48],"FIREBIRD_DATABASE_DIR","properties",{"_54":55,"_59":60,"_64":65,"_68":69,"_47":71,"_46":74,"_48":76,"_51":79},"LOG_LEVEL",{"_56":57,"_12":58},"description","Logging level for debugging (e.g., debug)","string","FIREBIRD_HOST",{"_61":62,"_56":63,"_12":58},"default","localhost","The hostname of the Firebird database server","FIREBIRD_PORT",{"_61":66,"_56":67,"_12":58},"3050","The port number of the Firebird database server","FIREBIRD_ROLE",{"_56":70,"_12":58},"Optional database role",{"_61":72,"_56":73,"_12":58},"SYSDBA","Username for connecting to the Firebird database",{"_56":75,"_12":58},"Path to the Firebird database file (.fdb)",{"_61":77,"_56":78,"_12":58},"masterkey","Password for connecting to the Firebird database",{"_56":80,"_12":58},"Directory containing multiple Firebird databases","object",[83,84,85,86,87,88,89,83],"author:claimed","category:databases","hosting:hybrid","language:javascript","security_grade:a","quality_grade:a","license_grade:a","descriptionMarkdown","A server implementing Anthropic's Model Context Protocol (MCP) for Firebird SQL databases, enabling Claude and other LLMs to securely access, analyze, and manipulate data in Firebird databases through natural language.","descriptionPlainText","githubProject",{"_95":96,"_97":98},"readme","# MCP Firebird\n\nImplementation of Anthropic's MCP protocol for Firebird databases.\n\n## What is MCP Firebird and what is it for?\n\nMCP Firebird is a server that implements Anthropic's [Model Context Protocol (MCP)](https://github.com/anthropics/anthropic-cookbook/tree/main/model_context_protocol) for Firebird SQL databases. It allows Large Language Models (LLMs) like Claude to access, analyze, and manipulate data in Firebird databases securely and in a controlled manner.\n\nYou'll find use cases and examples below.\n\n## Installation\n\n```bash\n# Global installation\nnpm install -g mcp-firebird\n\n# Project installation\nnpm install mcp-firebird\n```\n\n## Configuration\n\n### Environment Variables\n\nYou can configure the server using environment variables:\n\n```bash\n# Basic configuration\nexport FIREBIRD_HOST=localhost\nexport FIREBIRD_PORT=3050\nexport FIREBIRD_DATABASE=/path/to/database.fdb\nexport FIREBIRD_USER=SYSDBA\nexport FIREBIRD_PASSWORD=masterkey\nexport FIREBIRD_ROLE=undefined # Optional\n\n# Directory configuration (alternative)\nexport FIREBIRD_DATABASE_DIR=/path/to/databases # Directory with databases\n```\n\n### Using with npx\n\nYou can run the server directly with npx:\n\n```bash\nnpx mcp-firebird --host localhost --port 3050 --database /path/to/database.fdb --user SYSDBA --password masterkey\n```\n\n## Configuration with Claude Desktop\n\nTo use the Firebird MCP server with Claude Desktop:\n\n\n \n ```bash\n code ~/Library/Application\\ Support/Claude/claude_desktop_config.json\n ```\n \n \n ```powershell\n code $env:AppData\\Claude\\claude_desktop_config.json\n ```\n \n\n\nAdd the following configuration:\n\n```json\n{\n \"mcpServers\": {\n \"mcp-firebird\": {\n \"command\": \"npx\",\n \"args\": [\n \"mcp-firebird\",\n \"--host\",\n \"localhost\",\n \"--port\",\n \"3050\",\n \"--database\",\n \"C:\\\\Databases\\\\example.fdb\",\n \"--user\",\n \"SYSDBA\",\n \"--password\",\n \"masterkey\"\n ]\n }\n }\n}\n```\n\n\n Make sure to use absolute paths in the configuration.\n\n\n\n After saving the file, you need to restart Claude Desktop completely.\n\n\n## Resources and Features\n\nThe MCP Firebird server offers:\n\n- **Databases**: List of all available databases\n- **Tables**: List of all tables in the database\n- **Views**: List of all views in the database\n- **Stored procedures**: Access to procedures in the database\n- **Table schemas**: Detailed structure of each table\n- **Data**: Access to table data\n\n## Available Tools\n\n1. **list-tables**: Lists all tables in the database\n ```json\n {} // No parameters required\n ```\n\n2. **describe-table**: Describes the structure of a table\n ```json\n {\n \"tableName\": \"EMPLOYEES\"\n }\n ```\n\n3. **execute-query**: Executes an SQL query in the database\n ```json\n {\n \"sql\": \"SELECT * FROM EMPLOYEES WHERE DEPARTMENT_ID = 10\",\n \"params\": [] // Optional parameters for prepared queries\n }\n ```\n\n4. **get-field-descriptions**: Gets field descriptions\n ```json\n {\n \"tableName\": \"EMPLOYEES\"\n }\n ```\n\nThe **get-field-descriptions** tool is especially useful for AI models, as it retrieves comments from Firebird's RDB$DESCRIPTION metadata, providing additional semantic context about the purpose of each field.\n\n## Available Prompts\n\n1. **query-data**: Query data using natural language\n ```\n Find all employees in the sales department hired in 2023\n ```\n\n2. **analyze-table**: Analyze the structure of a table\n ```\n Analyze the EMPLOYEES table and explain its structure\n ```\n\n3. **optimize-query**: Optimize an SQL query\n ```\n Optimize: SELECT * FROM EMPLOYEES WHERE LAST_NAME = 'Smith'\n ```\n\n4. **generate-sql**: Generate SQL from a description\n ```\n Generate a query to get the 10 best-selling products\n ```\n\n## Usage from Different Languages\n\n### TypeScript/JavaScript\n\n```typescript\n// Example with TypeScript\nimport { McpClient, ChildProcessTransport } from '@modelcontextprotocol/sdk';\nimport { spawn } from 'child_process';\n\nasync function main() {\n // Start the MCP server process\n const serverProcess = spawn('npx', [\n 'mcp-firebird',\n '--database', '/path/to/database.fdb',\n '--user', 'SYSDBA',\n '--password', 'masterkey'\n ]);\n \n // Create a transport and an MCP client\n const transport = new ChildProcessTransport(serverProcess);\n const client = new McpClient(transport);\n \n try {\n // Get server information\n const serverInfo = await client.getServerInfo();\n console.log('MCP Server:', serverInfo);\n \n // List available tables\n const tablesResult = await client.executeTool('list-tables', {});\n console.log('Available tables:', tablesResult);\n \n // Execute an SQL query\n const queryResult = await client.executeTool('execute-query', {\n sql: 'SELECT FIRST 10 * FROM EMPLOYEES'\n });\n console.log('Query results:', queryResult);\n \n // Use a prompt to generate SQL\n const sqlGeneration = await client.executePrompt('generate-sql', {\n description: 'Get all premium customers'\n });\n console.log('Generated SQL:', sqlGeneration);\n } catch (error) {\n console.error('Error:', error);\n } finally {\n // Close the server process\n serverProcess.kill();\n }\n}\n\nmain().catch(console.error);\n```\n\n### Python\n\n```python\n# Example with Python\nimport json\nimport subprocess\nfrom subprocess import PIPE\n\nclass McpFirebirdClient:\n def __init__(self, database_path, user='SYSDBA', password='masterkey'):\n # Start the MCP server process\n self.process = subprocess.Popen(\n ['npx', 'mcp-firebird', '--database', database_path, '--user', user, '--password', password],\n stdin=PIPE,\n stdout=PIPE,\n stderr=PIPE,\n text=True,\n bufsize=1\n )\n \n def send_request(self, method, params={}):\n request = {\n 'id': 1,\n 'method': method,\n 'params': params\n }\n # Send the request to the server\n self.process.stdin.write(json.dumps(request) + '\\n')\n self.process.stdin.flush()\n \n # Read the response\n response_line = self.process.stdout.readline()\n while not response_line.strip() or response_line.startswith('['):\n response_line = self.process.stdout.readline()\n \n # Parse and return the JSON response\n return json.loads(response_line)\n \n def get_server_info(self):\n return self.send_request('getServerInfo')\n \n def list_tables(self):\n return self.send_request('executeTool', {'name': 'list-tables', 'args': {}})\n \n def execute_query(self, sql, params=[]):\n return self.send_request('executeTool', {\n 'name': 'execute-query',\n 'args': {'sql': sql, 'params': params}\n })\n \n def generate_sql(self, description):\n return self.send_request('executePrompt', {\n 'name': 'generate-sql',\n 'args': {'description': description}\n })\n \n def close(self):\n self.process.terminate()\n\n# Client usage\nclient = McpFirebirdClient('/path/to/database.fdb')\ntry:\n # Get server information\n server_info = client.get_server_info()\n print(f\"MCP Server: {server_info}\")\n \n # List tables\n tables = client.list_tables()\n print(f\"Available tables: {tables}\")\n \n # Execute a query\n results = client.execute_query(\"SELECT FIRST 10 * FROM EMPLOYEES\")\n print(f\"Results: {results}\")\n \n # Generate SQL\n sql = client.generate_sql(\"List the best-selling products\")\n print(f\"Generated SQL: {sql}\")\nfinally:\n client.close()\n```\n\n### Delphi and Lazurus\n\n```delphi\n// Example with Delphi\nprogram McpFirebirdClient;\n\n{$APPTYPE CONSOLE}\n\nuses\n System.SysUtils, System.Classes, System.JSON, System.Net.HttpClient,\n System.Diagnostics, System.IOUtils;\n\ntype\n TMcpFirebirdClient = class\n private\n FProcess: TProcess; //For Delphi change to TProcessDelphi and add https://github.com/ferruhkoroglu/TProcessDelphi\n FRequestId: Integer;\n \n function SendRequest(const Method: string; const Params: TJSONObject = nil): TJSONObject;\n function ReadResponse: string;\n public\n constructor Create(const DatabasePath, User, Password: string);\n destructor Destroy; override;\n \n function GetServerInfo: TJSONObject;\n function ListTables: TJSONObject;\n function ExecuteQuery(const SQL: string; Params: TArray = nil): TJSONObject;\n function GenerateSQL(const Description: string): TJSONObject;\n end;\n\nconstructor TMcpFirebirdClient.Create(const DatabasePath, User, Password: string);\nbegin\n inherited Create;\n FRequestId := 1;\n \n // Create and configure the process\n FProcess := TProcess.Create(nil);\n FProcess.Executable := 'npx';\n FProcess.Parameters.Add('mcp-firebird');\n FProcess.Parameters.Add('--database');\n FProcess.Parameters.Add(DatabasePath);\n FProcess.Parameters.Add('--user');\n FProcess.Parameters.Add(User);\n FProcess.Parameters.Add('--password');\n FProcess.Parameters.Add(Password);\n \n FProcess.Options := [poUsePipes, poStderrToOutPut];\n FProcess.Execute;\n \n // Wait for the server to start\n Sleep(2000);\nend;\n\ndestructor TMcpFirebirdClient.Destroy;\nbegin\n FProcess.Free;\n inherited;\nend;\n\nfunction TMcpFirebirdClient.SendRequest(const Method: string; const Params: TJSONObject = nil): TJSONObject;\nvar\n Request: TJSONObject;\n RequestStr, ResponseStr: string;\nbegin\n // Create the JSON request\n Request := TJSONObject.Create;\n try\n Request.AddPair('id', TJSONNumber.Create(FRequestId));\n Inc(FRequestId);\n Request.AddPair('method', Method);\n \n if Assigned(Params) then\n Request.AddPair('params', Params)\n else\n Request.AddPair('params', TJSONObject.Create);\n \n RequestStr := Request.ToString + #10;\n \n // Send the request to the process\n FProcess.Input.Write(RequestStr[1], Length(RequestStr) * 2);\n \n // Read the response\n ResponseStr := ReadResponse;\n Result := TJSONObject.ParseJSONValue(ResponseStr) as TJSONObject;\n finally\n Request.Free;\n end;\nend;\n\nfunction TMcpFirebirdClient.ReadResponse: string;\nvar\n Buffer: TBytes;\n BytesRead: Integer;\n ResponseStr: string;\nbegin\n SetLength(Buffer, 4096);\n ResponseStr := '';\n \n repeat\n BytesRead := FProcess.Output.Read(Buffer[0], Length(Buffer));\n if BytesRead > 0 then\n begin\n SetLength(Buffer, BytesRead);\n ResponseStr := ResponseStr + TEncoding.UTF8.GetString(Buffer);\n end;\n until BytesRead = 0;\n \n Result := ResponseStr;\nend;\n\nfunction TMcpFirebirdClient.GetServerInfo: TJSONObject;\nbegin\n Result := SendRequest('getServerInfo');\nend;\n\nfunction TMcpFirebirdClient.ListTables: TJSONObject;\nvar\n Params: TJSONObject;\nbegin\n Params := TJSONObject.Create;\n try\n Params.AddPair('name', 'list-tables');\n Params.AddPair('args', TJSONObject.Create);\n Result := SendRequest('executeTool', Params);\n finally\n Params.Free;\n end;\nend;\n\nfunction TMcpFirebirdClient.ExecuteQuery(const SQL: string; Params: TArray = nil): TJSONObject;\nvar\n RequestParams, Args: TJSONObject;\n ParamsArray: TJSONArray;\n I: Integer;\nbegin\n RequestParams := TJSONObject.Create;\n Args := TJSONObject.Create;\n ParamsArray := TJSONArray.Create;\n \n try\n // Configure the arguments\n Args.AddPair('sql', SQL);\n \n if Length(Params) > 0 then\n begin\n for I := 0 to Length(Params) - 1 do\n begin\n case VarType(Params[I]) of\n varInteger: ParamsArray.Add(TJSONNumber.Create(Integer(Params[I])));\n varDouble: ParamsArray.Add(TJSONNumber.Create(Double(Params[I])));\n varBoolean: ParamsArray.Add(TJSONBool.Create(Boolean(Params[I])));\n else ParamsArray.Add(String(Params[I]));\n end;\n end;\n end;\n \n Args.AddPair('params', ParamsArray);\n RequestParams.AddPair('name', 'execute-query');\n RequestParams.AddPair('args', Args);\n \n Result := SendRequest('executeTool', RequestParams);\n finally\n RequestParams.Free;\n end;\nend;\n\nfunction TMcpFirebirdClient.GenerateSQL(const Description: string): TJSONObject;\nvar\n RequestParams, Args: TJSONObject;\nbegin\n RequestParams := TJSONObject.Create;\n Args := TJSONObject.Create;\n \n try\n Args.AddPair('description', Description);\n RequestParams.AddPair('name', 'generate-sql');\n RequestParams.AddPair('args', Args);\n \n Result := SendRequest('executePrompt', RequestParams);\n finally\n RequestParams.Free;\n end;\nend;\n\nvar\n Client: TMcpFirebirdClient;\n ServerInfo, Tables, QueryResults, GeneratedSQL: TJSONObject;\n\nbegin\n try\n WriteLn('Starting MCP Firebird client...');\n \n // Create the client\n Client := TMcpFirebirdClient.Create('C:\\Databases\\example.fdb', 'SYSDBA', 'masterkey');\n try\n // Get server information\n ServerInfo := Client.GetServerInfo;\n WriteLn('Server information: ', ServerInfo.ToString);\n \n // List tables\n Tables := Client.ListTables;\n WriteLn('Available tables: ', Tables.ToString);\n \n // Execute a query\n QueryResults := Client.ExecuteQuery('SELECT FIRST 10 * FROM EMPLOYEES');\n WriteLn('Query results: ', QueryResults.ToString);\n \n // Generate SQL\n GeneratedSQL := Client.GenerateSQL('Get all premium customers');\n WriteLn('Generated SQL: ', GeneratedSQL.ToString);\n finally\n Client.Free;\n end;\n except\n on E: Exception do\n WriteLn('Error: ', E.Message);\n end;\n \n WriteLn('Press ENTER to exit...');\n ReadLn;\nend.\n```\n\n## Docker Configuration\n\nYou can run the MCP Firebird server in a Docker container:\n\n### Dockerfile\n\n```dockerfile\nFROM node:18-alpine\n\n# Install necessary dependencies for Firebird\nRUN apk add --no-cache firebird-client\n\n# Create application directory\nWORKDIR /app\n\n# Copy project files\nCOPY package*.json ./\nRUN npm install\n\n# Copy source code\nCOPY . .\n\n# Compile the TypeScript project\nRUN npm run build\n\n# Expose port if HTTP is used (optional)\n# EXPOSE 3000\n\n# Set default environment variables\nENV FIREBIRD_HOST=firebird-db\nENV FIREBIRD_PORT=3050\nENV FIREBIRD_USER=SYSDBA\nENV FIREBIRD_PASSWORD=masterkey\nENV FIREBIRD_DATABASE=/firebird/data/database.fdb\n\n# Start command\nCMD [\"node\", \"dist/index.js\"]\n```\n\n### Docker Compose\n\n```yaml\nversion: '3.8'\n\nservices:\n # Firebird database server\n firebird-db:\n image: jacobalberty/firebird:3.0\n environment:\n ISC_PASSWORD: masterkey\n FIREBIRD_DATABASE: database.fdb\n FIREBIRD_USER: SYSDBA\n volumes:\n - firebird-data:/firebird/data\n ports:\n - \"3050:3050\"\n networks:\n - mcp-network\n\n # MCP Firebird server\n mcp-firebird:\n build:\n context: .\n dockerfile: Dockerfile\n environment:\n FIREBIRD_HOST: firebird-db\n FIREBIRD_PORT: 3050\n FIREBIRD_USER: SYSDBA\n FIREBIRD_PASSWORD: masterkey\n FIREBIRD_DATABASE: /firebird/data/database.fdb\n depends_on:\n - firebird-db\n networks:\n - mcp-network\n # For use with Claude Desktop, expose STDIO\n stdin_open: true\n tty: true\n\nnetworks:\n mcp-network:\n driver: bridge\n\nvolumes:\n firebird-data:\n```\n\n### Running with Docker\n\n```bash\n# Build and run with Docker Compose\ndocker compose up -d\n\n# Check logs\ndocker compose logs -f mcp-firebird\n\n# Stop services\ndocker compose down\n```\n\n### Use Cases\n\n1. **Data Analysis with AI**:\n - Analyze historical sales trends\n - Identify patterns in financial data\n - Detect anomalies in transaction records\n\n2. **SQL Query Generation**:\n - Create complex queries from natural language descriptions\n - Optimize existing queries to improve performance\n - Translate queries between different SQL dialects\n\n3. **Automated Documentation**:\n - Generate documentation about database structure\n - Explain relationships between tables and schemas\n - Create detailed data dictionaries\n\n4. **Development Assistance**:\n - Suggest indexes to improve performance\n - Propose schema normalizations\n - Help with data migration between systems\n\n### Example of Sales Analysis Usage\n\nInteraction with Claude:\n\n```\nUser: Connect to my Firebird database and analyze sales trends by region in the last quarter.\n\nClaude: I'll connect to your Firebird database to analyze regional sales trends.\n\n[Claude uses MCP Firebird to execute several SQL queries]\n\nBased on data from the last quarter, I've identified the following trends:\n\n1. The North region has experienced 12.5% growth compared to the previous quarter\n2. The South region shows a 3.2% decrease in electronics products\n3. The \"Laptop Pro X\" product is the best-selling across all regions\n4. Sales in the East region show a cyclical pattern with peaks on weekends\n\nGraphically, the distribution of sales by region is:\n[Graph generated by Claude based on the data]\n\nWould you like to delve deeper into any specific region or product category?\n```\n\n### Example of Query Optimization\n\n```\nUser: I have this query that's running slowly, can you optimize it?\nSELECT c.CUSTOMER_NAME, SUM(o.ORDER_TOTAL) \nFROM CUSTOMERS c \nJOIN ORDERS o ON c.CUSTOMER_ID = o.CUSTOMER_ID \nWHERE o.ORDER_DATE > '2024-01-01' \nGROUP BY c.CUSTOMER_NAME \nORDER BY SUM(o.ORDER_TOTAL) DESC\n\nClaude: I'll analyze this query to optimize it.\n\n[Claude uses MCP Firebird to analyze the schema and query]\n\nI've identified several optimization opportunities:\n\n1. The current query doesn't efficiently use indexes\n2. The calculation of SUM(o.ORDER_TOTAL) is performed twice\n\nHere's the optimized version:\n\n```sql\nSELECT c.CUSTOMER_NAME, total_sales\nFROM CUSTOMERS c \nJOIN (\n SELECT CUSTOMER_ID, SUM(ORDER_TOTAL) as total_sales\n FROM ORDERS \n WHERE ORDER_DATE > '2024-01-01'\n GROUP BY CUSTOMER_ID\n) o ON c.CUSTOMER_ID = o.CUSTOMER_ID \nORDER BY total_sales DESC\n```\n\nThis version:\n- Reduces the dataset before joining\n- Calculates the sum only once\n- Could benefit from an index on ORDERS(ORDER_DATE, CUSTOMER_ID, ORDER_TOTAL)\n\nWhen running both queries on your database, the optimized version is approximately 45% faster.\n```\n\n## Security Configuration\n\nSecurity is a priority in MCP Firebird. Below are advanced options to control access and permitted operations.\n\n### Limiting Access to Tables and Views\n\nYou can restrict which tables and views are available to the MCP server using inclusion and exclusion filters:\n\n```javascript\n// In your custom configuration (config.js)\nmodule.exports = {\n // Basic configuration...\n \n security: {\n // Only allow access to these tables\n allowedTables: [\n 'CUSTOMERS', \n 'PRODUCTS', \n 'ORDERS',\n 'ORDER_ITEMS'\n ],\n \n // Explicitly exclude these tables (takes precedence over allowedTables)\n forbiddenTables: [\n 'USERS',\n 'USER_CREDENTIALS',\n 'AUDIT_LOG'\n ],\n \n // Table name pattern filter (regular expression)\n tableNamePattern: '^(?!TMP_|TEMP_|BAK_).*$' // Exclude temporary/backup tables\n }\n};\n```\n\nTo use this configuration:\n\n```bash\nnpx mcp-firebird --config ./config.js\n```\n\n### Limiting SQL Operations\n\nYou can restrict which SQL operations are allowed:\n\n```javascript\n// In your custom configuration\nmodule.exports = {\n // Basic configuration...\n \n security: {\n // Allowed SQL operations\n allowedOperations: ['SELECT', 'EXECUTE'], // Only queries and stored procedures\n \n // Specifically block these operations\n forbiddenOperations: ['DROP', 'TRUNCATE', 'ALTER', 'GRANT', 'REVOKE'],\n \n // Maximum number of rows that can be returned in a query\n maxRows: 1000,\n \n // Maximum query execution time (in ms)\n queryTimeout: 5000\n }\n};\n```\n\n### Restricting Sensitive Data\n\nYou can configure rules to mask or filter sensitive data:\n\n```javascript\nmodule.exports = {\n // Basic configuration...\n \n security: {\n dataMasking: [\n {\n // Mask specific columns\n columns: ['CREDIT_CARD_NUMBER', 'SSN', 'PASSWORD'],\n pattern: /^.*/,\n replacement: '************'\n },\n {\n // Partially mask emails\n columns: ['EMAIL'],\n pattern: /^(.{3})(.*)(@.*)$/,\n replacement: '$1***$3'\n }\n ],\n \n // Row filters to exclude sensitive data\n rowFilters: {\n 'CUSTOMERS': 'GDPR_CONSENT = 1', // Only show customers with GDPR consent\n 'EMPLOYEES': 'IS_PUBLIC_PROFILE = 1' // Only public employee profiles\n }\n }\n};\n```\n\n### Audit Logging\n\nConfigure detailed logging of all operations performed through MCP:\n\n```javascript\nmodule.exports = {\n // Basic configuration...\n \n security: {\n audit: {\n // Enable auditing\n enabled: true,\n \n // Audit log destination\n destination: 'database', // options: 'file', 'database', 'both'\n \n // If destination includes 'file'\n auditFile: '/path/to/audit.log',\n \n // If destination includes 'database'\n auditTable: 'MCP_AUDIT_LOG',\n \n // Detail level\n detailLevel: 'full', // 'basic', 'medium', 'full'\n \n // What to log\n logQueries: true,\n logResponses: true,\n logParameters: true\n }\n }\n};\n```\n\n### Audit Logging Example\n\n```sql\n-- Table structure for auditing\nCREATE TABLE MCP_AUDIT_LOG (\n LOG_ID INT NOT NULL PRIMARY KEY,\n TIMESTAMP TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n CLIENT_INFO VARCHAR(255),\n OPERATION_TYPE VARCHAR(50),\n TARGET_OBJECT VARCHAR(100),\n QUERY_TEXT BLOB SUB_TYPE TEXT,\n PARAMETERS BLOB SUB_TYPE TEXT,\n AFFECTED_ROWS INT,\n EXECUTION_TIME INT,\n USER_IDENTIFIER VARCHAR(100),\n SUCCESS BOOLEAN\n);\n\n-- Example log entry\nINSERT INTO MCP_AUDIT_LOG (\n LOG_ID, CLIENT_INFO, OPERATION_TYPE, TARGET_OBJECT, \n QUERY_TEXT, PARAMETERS, AFFECTED_ROWS, \n EXECUTION_TIME, USER_IDENTIFIER, SUCCESS\n) VALUES (\n NEXT VALUE FOR SEQ_AUDIT_LOG, 'Claude/agent', 'SELECT', 'CUSTOMERS',\n 'SELECT CUSTOMER_NAME, CITY FROM CUSTOMERS WHERE REGION = ?', \n '[\"East\"]', 24, 45, 'claude-session-123', TRUE\n);\n```\n\n### Data Volume Limitations\n\nConfigure limits to prevent queries that consume too many resources:\n\n```javascript\nmodule.exports = {\n // Basic configuration...\n \n security: {\n resourceLimits: {\n // Row limit per query\n maxRowsPerQuery: 5000,\n \n // Result size limit (in bytes)\n maxResponseSize: 1024 * 1024 * 5, // 5 MB\n \n // CPU time limit per query (ms)\n maxQueryCpuTime: 10000,\n \n // Query limit per session\n maxQueriesPerSession: 100,\n \n // Rate limiting (queries per minute)\n rateLimit: {\n queriesPerMinute: 60,\n burstLimit: 20\n }\n }\n }\n};\n```\n\n### Integration with External Authorization Systems\n\nMCP Firebird can integrate with external authorization systems for more precise access control:\n\n```javascript\nmodule.exports = {\n // Basic configuration...\n \n security: {\n authorization: {\n // Use an external authorization service\n type: 'oauth2',\n \n // Configuration for OAuth2\n oauth2: {\n tokenVerifyUrl: 'https://auth.example.com/verify',\n clientId: 'mcp-firebird-client',\n clientSecret: process.env.OAUTH_CLIENT_SECRET,\n scope: 'database:read'\n },\n \n // Role to permission mapping\n rolePermissions: {\n 'analyst': {\n tables: ['SALES', 'PRODUCTS', 'CUSTOMERS'],\n operations: ['SELECT']\n },\n 'manager': {\n tables: ['SALES', 'PRODUCTS', 'CUSTOMERS', 'EMPLOYEES'],\n operations: ['SELECT', 'INSERT', 'UPDATE']\n },\n 'admin': {\n allTablesAllowed: true,\n operations: ['SELECT', 'INSERT', 'UPDATE', 'DELETE']\n }\n }\n }\n }\n};\n```\n\n### Practical Security Examples\n\n#### Example 1: MCP Server for Sales Analysis\n\n```javascript\n// config-sales-analysis.js\nmodule.exports = {\n database: process.env.FIREBIRD_DATABASE,\n user: process.env.FIREBIRD_USER,\n password: process.env.FIREBIRD_PASSWORD,\n \n security: {\n // Limited access to sales tables\n allowedTables: [\n 'SALES', 'PRODUCTS', 'CUSTOMERS', 'REGIONS',\n 'SALES_TARGETS', 'PRODUCT_CATEGORIES'\n ],\n \n // Only allow SELECT queries\n allowedOperations: ['SELECT'],\n \n // Mask sensitive customer data\n dataMasking: [\n {\n columns: ['CUSTOMER_EMAIL', 'CUSTOMER_PHONE'],\n pattern: /^.*/,\n replacement: '[REDACTED]'\n }\n ],\n \n // Resource limits\n resourceLimits: {\n maxRowsPerQuery: 10000,\n maxQueryCpuTime: 5000\n }\n }\n};\n```\n\nClaude Desktop config:\n\n```json\n{\n \"mcpServers\": {\n \"mcp-firebird-sales\": {\n \"command\": \"npx\",\n \"args\": [\n \"mcp-firebird\",\n \"--config\",\n \"C:\\\\config\\\\config-sales-analysis.js\"\n ]\n }\n }\n}\n```\n\n#### Example 2: MCP Server for Inventory Management\n\n```javascript\n// config-inventory.js\nmodule.exports = {\n database: process.env.FIREBIRD_DATABASE,\n user: process.env.FIREBIRD_USER,\n password: process.env.FIREBIRD_PASSWORD,\n \n security: {\n // Access to inventory tables\n allowedTables: [\n 'INVENTORY', 'PRODUCTS', 'WAREHOUSES', \n 'STOCK_MOVEMENTS', 'SUPPLIERS'\n ],\n \n // Allow limited read and write operations\n allowedOperations: ['SELECT', 'INSERT', 'UPDATE'],\n \n // Prevent modification of historical records\n rowFilters: {\n 'STOCK_MOVEMENTS': 'MOVEMENT_DATE > DATEADD(-30 DAY TO CURRENT_DATE)'\n },\n \n // Full auditing\n audit: {\n enabled: true,\n destination: 'both',\n auditFile: 'C:\\\\logs\\\\inventory-audit.log',\n auditTable: 'MCP_INVENTORY_AUDIT',\n detailLevel: 'full'\n }\n }\n};\n```\n\n#### Example 3: Configuration for Development and Testing\n\n```javascript\n// config-development.js\nmodule.exports = {\n database: process.env.FIREBIRD_DATABASE_DEV,\n user: process.env.FIREBIRD_USER_DEV,\n password: process.env.FIREBIRD_PASSWORD_DEV,\n \n security: {\n // In development, allow more operations\n allowedOperations: ['SELECT', 'INSERT', 'UPDATE', 'DELETE', 'CREATE'],\n \n // Exclude only critical tables\n forbiddenTables: ['SYSTEM_CONFIG', 'APP_SECRETS'],\n \n // Limit impact of heavy queries\n resourceLimits: {\n maxRowsPerQuery: 1000,\n maxQueryCpuTime: 3000,\n queriesPerMinute: 120\n },\n \n // Basic auditing\n audit: {\n enabled: true,\n destination: 'file',\n auditFile: './logs/dev-audit.log',\n detailLevel: 'basic'\n }\n }\n};\n```\n\nThese examples illustrate how MCP Firebird can be configured for different use cases, each with its own security and data access considerations.\n\n## Integration with AI Agents\n\n### Claude in the Terminal\n\nYou can use the MCP Firebird server with Claude in the terminal:\n\n```bash\n# Start the MCP server in one terminal\nnpx mcp-firebird --database /path/to/database.fdb --user SYSDBA --password masterkey\n\n# In another terminal, use anthropic CLI with MCP\nanthropic messages create \\\n --model claude-3-opus-20240229 \\\n --max-tokens 4096 \\\n --mcp \"npx mcp-firebird --database /path/to/database.fdb --user SYSDBA --password masterkey\" \\\n --message \"Analyze the structure of my Firebird database\"\n```\n\n### Other AI Agents\n\nThe MCP Firebird server is compatible with any agent that implements the MCP protocol, simply by providing the command to start the server:\n\n```\nnpx mcp-firebird --database /path/to/database.fdb --user SYSDBA --password masterkey\n```\n\n## Security\n\nThe server implements the following security measures:\n\n- Input validation with Zod\n- SQL query sanitization\n- Secure credential handling\n- SQL injection prevention\n- Restriction of destructive operations\n\n## Debugging and Troubleshooting\n\nTo enable debug mode:\n\n```bash\nexport LOG_LEVEL=debug\n```\n\n### Common Issues\n\n1. **Database connection error**:\n - Verify credentials and database path\n - Make sure the Firebird server is running\n - Check that the user has sufficient permissions\n\n2. **Server doesn't appear in Claude Desktop**:\n - Restart Claude Desktop\n - Verify the configuration in `claude_desktop_config.json`\n - Make sure the database path is absolute\n\n3. **STDIO issues**:\n - Ensure standard output is not being redirected\n - Don't use `console.log` for debugging (use `console.error` instead)\n\n## License\n\nMIT\n","url","https://github.com/PuroDelphi/mcpFirebird","githubRepository",{"_101":102,"_103":104,"_105":106,"_107":108,"_109":110,"_111":112,"_116":117,"_118":119,"_121":117},"defaultBranch","main","fullName","PuroDelphi/mcpFirebird","githubTreeId",103002,"language","JavaScript","name","mcpFirebird","owner",{"_113":114,"_8":115},"login","PuroDelphi","ESXKxb6dDj","recentStargazers",3,"spdxLicense",{"_109":120},"MIT License","stargazers","glamaJson","id",3470,"inspectable",true,"integrations",[129,139,146,152,159,166],{"_130":131,"_56":137,"_8":138},"brand",{"_132":133,"_109":134,"_135":136},"logoSvgPath","M23.922 10.66a11.925 11.925 0 0 0-1.93-5.299 12.002 12.002 0 0 0-1.362-1.692A11.993 11.993 0 0 0 15.271.455a11.916 11.916 0 0 0-2.88-.444c-.237-.005-.474-.015-.71-.004-.345.016-.69.036-1.033.077-.385.046-.77.108-1.15.182a11.947 11.947 0 0 0-4.906 2.297A12.012 12.012 0 0 0 .394 8.94a11.886 11.886 0 0 0-.393 2.883c-.009.51.016 1.019.073 1.526a11.954 11.954 0 0 0 3.103 6.79 11.982 11.982 0 0 0 8.442 3.858c.013 0 .818-.002.868-.004.518-.02 1.032-.076 1.543-.162a11.947 11.947 0 0 0 6.173-3.072 11.975 11.975 0 0 0 3.667-7.028c.053-.406.087-.815.113-1.224.038-.617.006-1.234-.062-1.848zM4.5 11.777c-.052.3-.094.601-.097.906-.003.253-.005.506.004.76.005.148.031.297.051.445.033.252-.067.455-.297.56a.473.473 0 0 1-.227.035c-.217-.019-.433-.05-.65-.077-.073-.01-.147-.017-.22-.03-.017-.003-.04-.025-.042-.041-.041-.249-.086-.497-.115-.747-.024-.206-.03-.413-.043-.62-.006-.118-.014-.236-.013-.355.002-.197.005-.394.017-.59.014-.218.034-.436.06-.653.02-.177.045-.355.083-.529.062-.29.134-.579.207-.867.07-.275.162-.542.273-.804.08-.187.15-.377.235-.56.09-.195.188-.387.295-.573.12-.21.251-.414.382-.619.083-.13.17-.259.26-.384.074-.102.155-.197.234-.295.072-.088.142-.178.217-.263a7.6 7.6 0 0 1 .25-.274c.123-.128.247-.254.373-.378.087-.085.176-.17.27-.248.173-.145.346-.293.528-.427.227-.168.46-.329.697-.483.186-.12.375-.235.572-.336.253-.129.513-.244.773-.359.159-.07.321-.133.486-.19a11.02 11.02 0 0 1 1.312-.359c.279-.05.56-.086.841-.12.194-.023.39-.042.586-.044.312-.003.625-.004.936.019.342.024.683.07 1.023.118.182.026.362.071.54.117.288.075.578.146.86.24.246.08.487.182.724.288.26.116.513.245.767.374.107.054.21.118.311.183.195.124.392.246.58.38.189.135.368.282.55.424.016.012.03.026.05.045-.165.109-.325.211-.481.318-.168.116-.334.235-.5.353-.105.073-.211.145-.315.219-.13.092-.258.187-.387.28l-.45.321c-.11.08-.218.162-.327.243-.129.096-.26.19-.387.288-.217.167-.443.138-.643.003a6.527 6.527 0 0 0-1.757-.83 5.884 5.884 0 0 0-1.33-.246c-.19-.013-.381-.018-.572-.025a4.367 4.367 0 0 0-.792.047 23.89 23.89 0 0 0-.62.105 5.084 5.084 0 0 0-.795.225 6.08 6.08 0 0 0-.527.218 7.22 7.22 0 0 0-.574.294c-.178.103-.347.222-.516.339-.108.073-.214.15-.313.233-.149.124-.292.255-.435.385-.26.235-.486.5-.697.778-.132.174-.25.36-.368.545a5.76 5.76 0 0 0-.489.967 6.298 6.298 0 0 0-.368 1.271zm13.278 5.496c-.175-.122-.353-.242-.527-.366a.5.5 0 0 1-.154-.237l-.222-.55-.21-.532c-.07-.17-.141-.34-.21-.512-.071-.176-.137-.355-.213-.53-.088-.204-.14-.427-.28-.606a4.738 4.738 0 0 0-.288-.337 2.613 2.613 0 0 0-.498-.413c-.14-.09-.298-.12-.457-.148-.449-.081-.896-.166-1.345-.248l-1.368-.246c-.39-.07-.78-.137-1.166-.218-.258-.054-.494.162-.518.407-.023.246.167.456.375.508.56.141 1.118.293 1.677.442.662.175 1.324.347 1.984.527.22.06.416.173.597.313.22.17.4.375.53.62.084.163.151.336.22.506.071.177.14.355.202.534.093.268.182.537.27.806.055.164.11.328.16.492.075.237.147.475.22.712.05.163.099.327.147.49l.184.638c.048.164.098.327.144.492.07.242.14.485.204.729.033.126-.065.268-.2.287-.273.038-.547.07-.821.104-.182.023-.364.043-.546.063l-.66.07c-.28.029-.558.06-.837.09-.118.012-.236.03-.355.028a1.03 1.03 0 0 1-.688-.261c-.144-.126-.223-.292-.316-.451-.078-.135-.152-.272-.235-.403a12.841 12.841 0 0 0-.398-.602c-.134-.187-.28-.365-.423-.544a6.035 6.035 0 0 0-.229-.265 6.95 6.95 0 0 0-.757-.737 8.876 8.876 0 0 0-.641-.488 5.608 5.608 0 0 0-1.755-.803c-.436-.112-.878-.195-1.333-.187a3.542 3.542 0 0 0-.678.07c-.16.034-.309.022-.441-.089-.073-.06-.104-.144-.146-.223-.017-.032-.027-.068-.044-.109.072-.02.143-.042.216-.058a1.93 1.93 0 0 1 .227-.042c.195-.023.39-.053.584-.058.281-.007.564-.01.844.012a7.816 7.816 0 0 1 1.592.321c.24.076.473.175.704.274.387.166.727.407 1.051.673.214.175.419.36.603.567.225.252.449.506.66.77.15.186.282.389.419.587.228.332.43.681.62 1.037.048.089.093.18.133.272.064.153.199.2.341.183l.572-.07.7-.08c.27-.028.54-.054.81-.084.208-.024.416-.05.624-.08.117-.018.202-.132.208-.254.006-.108-.045-.2-.077-.296-.089-.272-.184-.542-.276-.813-.09-.263-.177-.525-.266-.787-.092-.276-.183-.551-.277-.826-.064-.188-.131-.375-.196-.563-.054-.156-.104-.312-.16-.467-.067-.186-.137-.37-.208-.555-.037-.096-.074-.192-.12-.284a1.22 1.22 0 0 0-.482-.514c-.2-.12-.424-.159-.641-.22-.64-.18-1.28-.356-1.92-.533l-.825-.23c-.218-.06-.435-.129-.657-.177-.259-.057-.433-.212-.57-.427a1.32 1.32 0 0 1-.202-.583.867.867 0 0 1 .12-.546.919.919 0 0 1 .44-.382.7.7 0 0 1 .411-.041c.322.06.645.112.968.168.227.04.454.083.681.121.268.045.536.086.803.13.193.032.386.067.579.1.224.037.448.072.671.11.195.034.389.073.584.103.126.019.249.042.362.102.054.029.11.06.156.1.163.146.326.295.484.447.141.136.279.276.413.42a.945.945 0 0 1 .217.392c.033.115.077.227.117.34l.167.471.212.595c.062.178.122.356.185.534l.176.497.188.544.093.268-.013.01zm.708.363a3.104 3.104 0 0 1-.37-.169c-.03-.016-.039-.076-.054-.117-.07-.197-.138-.395-.206-.592l-.23-.664-.23-.653c-.094-.267-.185-.534-.279-.8a78.3 78.3 0 0 0-.2-.565c-.037-.101-.073-.203-.113-.304-.063-.161-.179-.285-.296-.407-.1-.104-.199-.209-.304-.306a18.166 18.166 0 0 0-.605-.537c-.149-.125-.334-.167-.522-.197a66.347 66.347 0 0 1-.603-.098c-.247-.04-.493-.083-.739-.125l-.665-.113-1.026-.172c-.279-.048-.557-.098-.836-.145-.197-.033-.393-.075-.591-.089-.11-.007-.226.026-.335.056a.939.939 0 0 0-.395.235c-.118.113-.21.247-.272.402-.12.306-.101.606.007.909.071.197.173.376.317.528.142.15.307.258.513.306.248.058.493.129.74.196.44.12.881.24 1.322.362l.842.233.841.235c.266.074.48.224.621.46.07.118.117.252.168.382.062.156.119.315.175.474.079.224.156.45.233.675l.194.567.163.489.167.477.19.562.278.816c.01.03.021.058.028.088.01.042-.015.066-.052.07-.167.02-.335.035-.503.054-.084.01-.169.023-.253.032-.177.02-.355.037-.532.058-.189.021-.377.046-.566.068l-.726.082a.5.5 0 0 1-.122.005.085.085 0 0 1-.057-.037c-.068-.127-.129-.257-.198-.382a12.05 12.05 0 0 0-.733-1.196 10.987 10.987 0 0 0-.99-1.204 7.197 7.197 0 0 0-.595-.552 5.461 5.461 0 0 0-.628-.452 3.313 3.313 0 0 0-.704-.345c-.288-.093-.568-.21-.859-.29-.288-.077-.586-.116-.879-.177-.277-.057-.558-.056-.838-.072-.125-.007-.251.003-.377.01-.143.008-.286.017-.428.031a2.592 2.592 0 0 0-.247.04c-.16.03-.318.062-.491.096-.051-.16-.107-.319-.154-.481a5.498 5.498 0 0 1-.2-1.027 5.23 5.23 0 0 1-.021-1.028c.033-.479.113-.951.258-1.41.095-.3.2-.599.344-.88.096-.187.191-.374.298-.554.08-.137.178-.265.271-.394.073-.1.146-.201.225-.297.07-.084.146-.165.223-.243.128-.13.257-.26.392-.383.09-.084.19-.159.288-.234.105-.08.21-.16.32-.232.148-.096.299-.187.45-.275.135-.078.27-.157.411-.22.211-.093.427-.176.643-.257a2.85 2.85 0 0 1 .383-.12c.247-.054.495-.104.744-.14.21-.03.423-.052.634-.052.27 0 .542.015.81.042.466.046.917.156 1.354.323a6.039 6.039 0 0 1 1.819 1.068c.207.175.409.356.583.564.196.231.388.466.57.708.056.074.081.174.112.266.072.213.141.428.208.643.086.274.167.55.252.824.064.208.133.414.198.622.072.231.14.464.211.696l.15.477.165.534c.05.163.103.325.153.489l.117.39c.037.118.077.236.114.355l.291.928.275.865c.01.035.024.07.035.105.02.065-.015.113-.076.09zm.157-12.752a.484.484 0 0 1-.272.408.062.062 0 0 1-.054-.005c-.077-.06-.148-.127-.227-.184-.237-.173-.471-.35-.716-.512a8.86 8.86 0 0 0-.706-.428c-.246-.132-.502-.244-.756-.358a5.709 5.709 0 0 0-.501-.201c-.28-.095-.563-.186-.848-.267a7.965 7.965 0 0 0-1.091-.215c-.3-.042-.6-.076-.903-.081-.176-.003-.352-.015-.528-.009-.28.01-.56.024-.84.047-.209.017-.416.05-.623.08-.289.04-.573.101-.852.183-.236.07-.471.14-.705.217a4.57 4.57 0 0 0-.422.16 10.614 10.614 0 0 0-1.438.718c-.18.107-.352.232-.525.354a7.506 7.506 0 0 0-.394.296 12.185 12.185 0 0 0-.962.865c-.114.115-.219.24-.325.363-.11.128-.223.254-.327.387a8.572 8.572 0 0 0-.653.956c-.098.164-.187.334-.276.503a8.949 8.949 0 0 0-.253.51c-.08.177-.147.358-.216.54a7.726 7.726 0 0 0-.311.986c-.074.335-.149.67-.2 1.01a10.101 10.101 0 0 0-.047 2.328c.028.268.073.534.11.805-.215 0-.4-.063-.512-.256a.766.766 0 0 1-.08-.242 7.924 7.924 0 0 1-.083-.53 12.5 12.5 0 0 1-.07-.702 8.464 8.464 0 0 1-.021-.723 10.525 10.525 0 0 1 .282-2.28c.092-.394.216-.778.363-1.153.078-.198.151-.398.242-.59.13-.273.268-.544.414-.81.105-.192.222-.38.346-.561.145-.214.3-.42.455-.627.102-.135.207-.268.317-.396.105-.121.217-.237.328-.353a9.419 9.419 0 0 1 .578-.56c.18-.155.359-.31.545-.456.145-.114.299-.216.45-.32.13-.09.258-.18.392-.26a13.292 13.292 0 0 1 .975-.531c.146-.07.297-.133.447-.196.116-.05.231-.101.35-.142.248-.084.497-.163.747-.24.137-.043.275-.084.416-.112.299-.062.598-.123.9-.17a7.19 7.19 0 0 1 .743-.078c.325-.016.65-.019.976-.015.216.003.433.022.648.045a9.735 9.735 0 0 1 2.377.532c.432.16.86.332 1.264.56.28.157.557.318.829.49.206.13.405.276.6.424.177.134.35.274.514.423a.43.43 0 0 1 .13.373z","Delphi","slug","delphi","Provides integration examples for Delphi applications to connect with the MCP Firebird server, allowing Delphi programs to execute SQL queries, list database tables, and generate SQL through the MCP protocol.","pn5ad05yl3",{"_130":140,"_56":144,"_8":145},{"_132":141,"_109":142,"_135":143},"M13.983 11.078h2.119a.186.186 0 00.186-.185V9.006a.186.186 0 00-.186-.186h-2.119a.185.185 0 00-.185.185v1.888c0 .102.083.185.185.185m-2.954-5.43h2.118a.186.186 0 00.186-.186V3.574a.186.186 0 00-.186-.185h-2.118a.185.185 0 00-.185.185v1.888c0 .102.082.185.185.185m0 2.716h2.118a.187.187 0 00.186-.186V6.29a.186.186 0 00-.186-.185h-2.118a.185.185 0 00-.185.185v1.887c0 .102.082.185.185.186m-2.93 0h2.12a.186.186 0 00.184-.186V6.29a.185.185 0 00-.185-.185H8.1a.185.185 0 00-.185.185v1.887c0 .102.083.185.185.186m-2.964 0h2.119a.186.186 0 00.185-.186V6.29a.185.185 0 00-.185-.185H5.136a.186.186 0 00-.186.185v1.887c0 .102.084.185.186.186m5.893 2.715h2.118a.186.186 0 00.186-.185V9.006a.186.186 0 00-.186-.186h-2.118a.185.185 0 00-.185.185v1.888c0 .102.082.185.185.185m-2.93 0h2.12a.185.185 0 00.184-.185V9.006a.185.185 0 00-.184-.186h-2.12a.185.185 0 00-.184.185v1.888c0 .102.083.185.185.185m-2.964 0h2.119a.185.185 0 00.185-.185V9.006a.185.185 0 00-.184-.186h-2.12a.186.186 0 00-.186.186v1.887c0 .102.084.185.186.185m-2.92 0h2.12a.185.185 0 00.184-.185V9.006a.185.185 0 00-.184-.186h-2.12a.185.185 0 00-.184.185v1.888c0 .102.082.185.185.185M23.763 9.89c-.065-.051-.672-.51-1.954-.51-.338.001-.676.03-1.01.087-.248-1.7-1.653-2.53-1.716-2.566l-.344-.199-.226.327c-.284.438-.49.922-.612 1.43-.23.97-.09 1.882.403 2.661-.595.332-1.55.413-1.744.42H.751a.751.751 0 00-.75.748 11.376 11.376 0 00.692 4.062c.545 1.428 1.355 2.48 2.41 3.124 1.18.723 3.1 1.137 5.275 1.137.983.003 1.963-.086 2.93-.266a12.248 12.248 0 003.823-1.389c.98-.567 1.86-1.288 2.61-2.136 1.252-1.418 1.998-2.997 2.553-4.4h.221c1.372 0 2.215-.549 2.68-1.009.309-.293.55-.65.707-1.046l.098-.288Z","Docker","docker","Offers Docker configuration for containerized deployment of the MCP Firebird server alongside a Firebird database, with detailed Dockerfile and docker-compose examples for production use.","7gy1l3y829",{"_130":147,"_56":150,"_8":151},{"_132":148,"_109":108,"_135":149},"M0 0h24v24H0V0zm22.034 18.276c-.175-1.095-.888-2.015-3.003-2.873-.736-.345-1.554-.585-1.797-1.14-.091-.33-.105-.51-.046-.705.15-.646.915-.84 1.515-.66.39.12.75.42.976.9 1.034-.676 1.034-.676 1.755-1.125-.27-.42-.404-.601-.586-.78-.63-.705-1.469-1.065-2.834-1.034l-.705.089c-.676.165-1.32.525-1.71 1.005-1.14 1.291-.811 3.541.569 4.471 1.365 1.02 3.361 1.244 3.616 2.205.24 1.17-.87 1.545-1.966 1.41-.811-.18-1.26-.586-1.755-1.336l-1.83 1.051c.21.48.45.689.81 1.109 1.74 1.756 6.09 1.666 6.871-1.004.029-.09.24-.705.074-1.65l.046.067zm-8.983-7.245h-2.248c0 1.938-.009 3.864-.009 5.805 0 1.232.063 2.363-.138 2.711-.33.689-1.18.601-1.566.48-.396-.196-.597-.466-.83-.855-.063-.105-.11-.196-.127-.196l-1.825 1.125c.305.63.75 1.172 1.324 1.517.855.51 2.004.675 3.207.405.783-.226 1.458-.691 1.811-1.411.51-.93.402-2.07.397-3.346.012-2.054 0-4.109 0-6.179l.004-.056z","javascript","Offers JavaScript client examples for integrating with the MCP Firebird server, allowing JavaScript applications to execute queries and manage Firebird database data.","y9465iy2bu",{"_130":153,"_56":157,"_8":158},{"_132":154,"_109":155,"_135":156},"M14.25.18l.9.2.73.26.59.3.45.32.34.34.25.34.16.33.1.3.04.26.02.2-.01.13V8.5l-.05.63-.13.55-.21.46-.26.38-.3.31-.33.25-.35.19-.35.14-.33.1-.3.07-.26.04-.21.02H8.77l-.69.05-.59.14-.5.22-.41.27-.33.32-.27.35-.2.36-.15.37-.1.35-.07.32-.04.27-.02.21v3.06H3.17l-.21-.03-.28-.07-.32-.12-.35-.18-.36-.26-.36-.36-.35-.46-.32-.59-.28-.73-.21-.88-.14-1.05-.05-1.23.06-1.22.16-1.04.24-.87.32-.71.36-.57.4-.44.42-.33.42-.24.4-.16.36-.1.32-.05.24-.01h.16l.06.01h8.16v-.83H6.18l-.01-2.75-.02-.37.05-.34.11-.31.17-.28.25-.26.31-.23.38-.2.44-.18.51-.15.58-.12.64-.1.71-.06.77-.04.84-.02 1.27.05zm-6.3 1.98l-.23.33-.08.41.08.41.23.34.33.22.41.09.41-.09.33-.22.23-.34.08-.41-.08-.41-.23-.33-.33-.22-.41-.09-.41.09zm13.09 3.95l.28.06.32.12.35.18.36.27.36.35.35.47.32.59.28.73.21.88.14 1.04.05 1.23-.06 1.23-.16 1.04-.24.86-.32.71-.36.57-.4.45-.42.33-.42.24-.4.16-.36.09-.32.05-.24.02-.16-.01h-8.22v.82h5.84l.01 2.76.02.36-.05.34-.11.31-.17.29-.25.25-.31.24-.38.2-.44.17-.51.15-.58.13-.64.09-.71.07-.77.04-.84.01-1.27-.04-1.07-.14-.9-.2-.73-.25-.59-.3-.45-.33-.34-.34-.25-.34-.16-.33-.1-.3-.04-.25-.02-.2.01-.13v-5.34l.05-.64.13-.54.21-.46.26-.38.3-.32.33-.24.35-.2.35-.14.33-.1.3-.06.26-.04.21-.02.13-.01h5.84l.69-.05.59-.14.5-.21.41-.28.33-.32.27-.35.2-.36.15-.36.1-.35.07-.32.04-.28.02-.21V6.07h2.09l.14.01zm-6.47 14.25l-.23.33-.08.41.08.41.23.33.33.23.41.08.41-.08.33-.23.23-.33.08-.41-.08-.41-.23-.33-.33-.23-.41-.08-.41.08z","Python","python","Includes Python client examples for connecting to the MCP server, enabling Python applications to execute SQL queries and interact with Firebird databases through the MCP protocol.","lupj5o9ef3",{"_130":160,"_56":164,"_8":165},{"_132":161,"_109":162,"_135":163},"M1.125 0C.502 0 0 .502 0 1.125v21.75C0 23.498.502 24 1.125 24h21.75c.623 0 1.125-.502 1.125-1.125V1.125C24 .502 23.498 0 22.875 0zm17.363 9.75c.612 0 1.154.037 1.627.111a6.38 6.38 0 0 1 1.306.34v2.458a3.95 3.95 0 0 0-.643-.361 5.093 5.093 0 0 0-.717-.26 5.453 5.453 0 0 0-1.426-.2c-.3 0-.573.028-.819.086a2.1 2.1 0 0 0-.623.242c-.17.104-.3.229-.393.374a.888.888 0 0 0-.14.49c0 .196.053.373.156.529.104.156.252.304.443.444s.423.276.696.41c.273.135.582.274.926.416.47.197.892.407 1.266.628.374.222.695.473.963.753.268.279.472.598.614.957.142.359.214.776.214 1.253 0 .657-.125 1.21-.373 1.656a3.033 3.033 0 0 1-1.012 1.085 4.38 4.38 0 0 1-1.487.596c-.566.12-1.163.18-1.79.18a9.916 9.916 0 0 1-1.84-.164 5.544 5.544 0 0 1-1.512-.493v-2.63a5.033 5.033 0 0 0 3.237 1.2c.333 0 .624-.03.872-.09.249-.06.456-.144.623-.25.166-.108.29-.234.373-.38a1.023 1.023 0 0 0-.074-1.089 2.12 2.12 0 0 0-.537-.5 5.597 5.597 0 0 0-.807-.444 27.72 27.72 0 0 0-1.007-.436c-.918-.383-1.602-.852-2.053-1.405-.45-.553-.676-1.222-.676-2.005 0-.614.123-1.141.369-1.582.246-.441.58-.804 1.004-1.089a4.494 4.494 0 0 1 1.47-.629 7.536 7.536 0 0 1 1.77-.201zm-15.113.188h9.563v2.166H9.506v9.646H6.789v-9.646H3.375z","TypeScript","typescript","Provides TypeScript client examples for integrating with the MCP server, enabling TypeScript applications to execute database queries and interact with Firebird databases through the MCP protocol.","64iqthhyvb",{"_130":167,"_56":171,"_8":172},{"_132":168,"_109":169,"_135":170},"M19.088 2.477 24 7.606 12.521 20.485l-.925 1.038L0 7.559l5.108-5.082h13.98Zm-17.434 5.2 6.934-4.003H5.601L1.619 7.636l.035.041Zm12.117-4.003L3.333 9.7l2.149 2.588 10.809-6.241-.2-.346 2.851-1.646-.365-.381h-4.806Zm7.52 2.834L8.257 14.034h5.101v-.4h3.667l5.346-5.998-1.08-1.128Zm-7.129 10.338H9.268l2.36 2.843 2.534-2.843Z","Zod","zod","Uses Zod for input validation as part of the server's security measures, ensuring that all inputs to the MCP server are properly validated before processing.","hwve5fkkn5","MCP Firebird","namespace","npmPackage",{"_109":177,"_178":179},"mcp-firebird","weeklyDownloads",4796,"prompts",[182,190,197,203],{"_109":183,"_184":185,"_56":189},"query-data","arguments",[186],{"_109":187,"_44":126,"_56":188},"sql","Consulta SQL a ejecutar","Ejecuta y analiza una consulta SQL en Firebird",{"_109":191,"_184":192,"_56":196},"analyze-table",[193],{"_109":194,"_44":126,"_56":195},"tableName","Nombre de la tabla a analizar","Analiza la estructura y datos de una tabla en Firebird",{"_109":198,"_184":199,"_56":202},"optimize-query",[200],{"_109":187,"_44":126,"_56":201},"Consulta SQL a optimizar","Optimiza una consulta SQL para Firebird",{"_109":204,"_184":205,"_56":208},"generate-sql",[206],{"_109":56,"_44":126,"_56":207},"Descripción de la consulta que se desea generar","Genera una consulta SQL para Firebird basada en una descripción","redditPostForeignId","relatedMcpServerIds",[212,213,214,215,216,217],251,1545,254,1673,1577,802,"resources",[220,224,227,230],{"_221":222,"_109":223},"uri","firebird://databases","databases",{"_221":225,"_109":226},"firebird://tables","tables",{"_221":228,"_109":229},"firebird://views","views",{"_221":231,"_109":232},"firebird://procedures","procedures","scores",{"_235":236,"_237":236,"_238":236},"license",100,"quality","security","simpleIcon","supportedPlatforms",[242,243,244],"WINDOWS","MACOS","LINUX","tools",[247,263,267,274],{"_109":248,"_249":250},"execute-query","inputSchema",{"_12":81,"_251":252,"_44":253,"_52":254,"_262":34},"$schema","http://json-schema.org/draft-07/schema#",[187],{"_187":255,"_258":259},{"_12":58,"_256":257,"_56":188},"minLength",1,"params",{"_12":260,"_56":261},"array","Parámetros opcionales para la consulta","additionalProperties",{"_109":264,"_249":265},"list-tables",{"_12":81,"_251":252,"_52":266,"_262":34},{},{"_109":268,"_249":269},"describe-table",{"_12":81,"_251":252,"_44":270,"_52":271,"_262":34},[194],{"_194":272},{"_12":58,"_256":257,"_56":273},"Nombre de la tabla a describir",{"_109":275,"_249":276},"get-field-descriptions",{"_12":81,"_251":252,"_44":277,"_52":278,"_262":34},[194],{"_194":279},{"_12":58,"_256":257,"_56":280},"Nombre de la tabla para obtener descripciones de campos","jh98erzet6","updatedAt",["D",1742918457206],"meta",[286,288,290,297,300,302,305,308,311,314,317,319,322,325,327,329,331,333,335],{"_10":287},"MCP Firebird | Glama",{"_289":91,"_109":56},"content",{"_291":292,"_293":294,"_295":296},"href","https://glama.ai/mcp/servers/@PuroDelphi/mcpFirebird","rel","canonical","tagName","link",{"_289":173,"_298":299},"property","og:title",{"_289":91,"_298":301},"og:description",{"_289":303,"_298":304},"https://glama.ai/logo.png","og:logo",{"_289":306,"_298":307},"https://glama.ai/mcp/servers/@PuroDelphi/mcpFirebird/og-image","og:image",{"_289":309,"_298":310},"630","og:image:height",{"_289":312,"_298":313},"1200","og:image:width",{"_289":315,"_298":316},"website","og:type",{"_289":292,"_298":318},"og:url",{"_289":320,"_298":321},"ChatGPT alternative for power users","og:site_name",{"_289":323,"_109":324},"summary_large_image","twitter:card",{"_289":320,"_109":326},"twitter:title",{"_289":91,"_109":328},"twitter:description",{"_289":306,"_109":330},"twitter:image",{"_289":309,"_109":332},"twitter:image:height",{"_289":312,"_109":334},"twitter:image:width",{"_336":337},"script:ld+json",{"_338":339,"_340":341},"@context","http://schema.org","@graph",[342],{"_338":343,"_344":345,"_346":347},"https://schema.org","@type","BreadcrumbList","itemListElement",[348,354,358,361],{"_344":349,"_350":351,"_109":352,"_353":257},"ListItem","item","https://glama.ai/","Glama","position",{"_344":349,"_350":355,"_109":356,"_353":357},"https://glama.ai/mcp","MCP",2,{"_344":349,"_350":359,"_109":360,"_353":117},"https://glama.ai/mcp/servers","Servers",{"_344":349,"_350":292,"_109":173,"_353":362},4,"routes/_public/mcp/servers/~namespace/~slug/_pages/reviews/_route",{"_32":-5,"_35":365,"_284":443,"_477":-5},{"_37":366,"_39":367,"_20":382,"_90":91,"_92":91,"_93":383,"_99":384,"_122":-5,"_123":124,"_125":126,"_127":387,"_109":173,"_174":114,"_175":400,"_180":401,"_209":-5,"_210":414,"_218":415,"_233":420,"_239":-5,"_135":110,"_240":421,"_245":422,"_8":281,"_282":442},["D",1742796211238],{"_41":368,"_52":373,"_12":81},[369,371],{"_44":370},[46,47,48],{"_44":372},[51,47,48],{"_54":374,"_59":375,"_64":376,"_68":377,"_47":378,"_46":379,"_48":380,"_51":381},{"_56":57,"_12":58},{"_61":62,"_56":63,"_12":58},{"_61":66,"_56":67,"_12":58},{"_56":70,"_12":58},{"_61":72,"_56":73,"_12":58},{"_56":75,"_12":58},{"_61":77,"_56":78,"_12":58},{"_56":80,"_12":58},[83,84,85,86,87,88,89,83],{"_95":96,"_97":98},{"_101":102,"_103":104,"_105":106,"_107":108,"_109":110,"_111":385,"_116":117,"_118":386,"_121":117},{"_113":114,"_8":115},{"_109":120},[388,390,392,394,396,398],{"_130":389,"_56":137,"_8":138},{"_132":133,"_109":134,"_135":136},{"_130":391,"_56":144,"_8":145},{"_132":141,"_109":142,"_135":143},{"_130":393,"_56":150,"_8":151},{"_132":148,"_109":108,"_135":149},{"_130":395,"_56":157,"_8":158},{"_132":154,"_109":155,"_135":156},{"_130":397,"_56":164,"_8":165},{"_132":161,"_109":162,"_135":163},{"_130":399,"_56":171,"_8":172},{"_132":168,"_109":169,"_135":170},{"_109":177,"_178":179},[402,405,408,411],{"_109":183,"_184":403,"_56":189},[404],{"_109":187,"_44":126,"_56":188},{"_109":191,"_184":406,"_56":196},[407],{"_109":194,"_44":126,"_56":195},{"_109":198,"_184":409,"_56":202},[410],{"_109":187,"_44":126,"_56":201},{"_109":204,"_184":412,"_56":208},[413],{"_109":56,"_44":126,"_56":207},[212,213,214,215,216,217],[416,417,418,419],{"_221":222,"_109":223},{"_221":225,"_109":226},{"_221":228,"_109":229},{"_221":231,"_109":232},{"_235":236,"_237":236,"_238":236},[242,243,244],[423,429,432,437],{"_109":248,"_249":424},{"_12":81,"_251":252,"_44":425,"_52":426,"_262":34},[187],{"_187":427,"_258":428},{"_12":58,"_256":257,"_56":188},{"_12":260,"_56":261},{"_109":264,"_249":430},{"_12":81,"_251":252,"_52":431,"_262":34},{},{"_109":268,"_249":433},{"_12":81,"_251":252,"_44":434,"_52":435,"_262":34},[194],{"_194":436},{"_12":58,"_256":257,"_56":273},{"_109":275,"_249":438},{"_12":81,"_251":252,"_44":439,"_52":440,"_262":34},[194],{"_194":441},{"_12":58,"_256":257,"_56":280},["D",1742918457206],[444,446,447,449,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465],{"_10":445},"Reviews | MCP Firebird | Glama",{"_289":91,"_109":56},{"_291":448,"_293":294,"_295":296},"https://glama.ai/mcp/servers/@PuroDelphi/mcpFirebird/reviews",{"_289":450,"_298":299},"Reviews | MCP Firebird",{"_289":91,"_298":301},{"_289":303,"_298":304},{"_289":306,"_298":307},{"_289":309,"_298":310},{"_289":312,"_298":313},{"_289":315,"_298":316},{"_289":448,"_298":318},{"_289":320,"_298":321},{"_289":323,"_109":324},{"_289":320,"_109":326},{"_289":91,"_109":328},{"_289":306,"_109":330},{"_289":309,"_109":332},{"_289":312,"_109":334},{"_336":466},{"_338":339,"_340":467},[468],{"_338":343,"_344":345,"_346":469},[470,471,472,473,474],{"_344":349,"_350":351,"_109":352,"_353":257},{"_344":349,"_350":355,"_109":356,"_353":357},{"_344":349,"_350":359,"_109":360,"_353":117},{"_344":349,"_350":292,"_109":173,"_353":362},{"_344":349,"_350":448,"_109":475,"_353":476},"Reviews",5,"review","actionData","errors"]

Rate & Review