🛠️ MCP Server with C# + Firebird
About
This project is an MCP (Model Context Protocol) server written in C# that provides tools for executing dynamic queries against a Firebird database. It supports filtering, record limits, and uses .NET 9 with FirebirdSql.Data.FirebirdClient.
Explore
- Single MCP tool: ListTable returns records from a Firebird table.
- Conditional SQL filtering via the filter parameter.
- Record limit enforced using Firebird’s FIRST clause.
- Built with .NET 9 and the official Firebird ADO.NET client.
- Configuration via appsettings.json for database connection.
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
🛠️ MCP Server with C# + FirebirdCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Install dependencies by nuget
`` bash``
dotnet add package ModelContextProtocol --prerelease
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"\ud83d\udee0\ufe0f mcp server with c# + firebird": {
"MCPServerCSharp": {
"command": "npx",
"args": [
"@modelcontextprotocol/inspector",
"dotnet",
"run"
]
}
}
}
}McpServers
{
"MCPServerCSharp": {
"command": "npx",
"args": [
"@modelcontextprotocol/inspector",
"dotnet",
"run"
]
}
}This project is an MCP ( Model Context Protocol ) server created in C#, with support for custom tools. One of the features included is the execution of dynamic queries in a Firebird database with filter and record limit.
---
📦 Technologies Used
- NPX - C# (.NET 9) - MCP ( Model Context Protocol ) - FirebirdSql.Data.FirebirdClient - Dependency Injection viaHost.CreateApplicationBuilder
- Configuration via appsettings.json
---
⚙️ Configuration
Install dependencies by nuget `` bash
dotnet add package ModelContextProtocol --prerelease
🔧
appsettings.json File
Create an
appsettings.json file in the project root with the following content:
json
{
"ConnectionStrings": {
"FirebirdDb": "Database=C:\\yourdata.fdb;User=SYSDBA;Password=masterkey;Dialect=3;Charset=NONE;" }
}
📝 Change the path of the .FDB file according to the location of your database.
📂 Recommended Project Structure
src/
├── MCPServer/
│ ├── Factory/
│ │ └── FbConnectionFactory.cs
│ ├── Tools/
│ │ └── FbQueries.cs
│ ├── Program.cs
│ └── appsettings.json
## 🧩 MCP Tool Available
🔍 ListTable
csharp
[McpTool, Description("List all records from a Firebird table")]
public List<Dictionary<string, object>> ListTable(string tableName, string filter = "", int limitRecords = 0)
This tool returns records from a Firebird database table with:
🔎 Conditional filter via SQL
🔢 Limitation of number of records (using FIRST)
Example of use:
json
{
"tool": "ListTable",
"args": {
"tableName": "CUSTOMERS",
"filter": "STATUS = 'ACTIVE'",
"limitRecords": 10
}
}
``Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
