Mcpservercsharp
What is Mcpservercsharp
MCPServerCSharp is a Modular Command Platform (MCP) server developed in C# that integrates with Firebird database, allowing for the execution of dynamic queries and custom tools.
Use cases
Use cases include querying customer records from a database, generating reports, and integrating with other applications that require database access and command execution.
How to use
To use MCPServerCSharp, set up the project by creating an ‘appsettings.json’ file with your Firebird database connection details, then run the server using the command ‘npx @modelcontextprotocol/inspector dotnet run’.
Key features
Key features include dynamic query execution in Firebird, support for custom tools, dependency injection, and configuration management through ‘appsettings.json’.
Where to use
MCPServerCSharp can be used in various fields such as database management, application development, and any scenario requiring modular command execution and database interaction.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Overview
What is Mcpservercsharp
MCPServerCSharp is a Modular Command Platform (MCP) server developed in C# that integrates with Firebird database, allowing for the execution of dynamic queries and custom tools.
Use cases
Use cases include querying customer records from a database, generating reports, and integrating with other applications that require database access and command execution.
How to use
To use MCPServerCSharp, set up the project by creating an ‘appsettings.json’ file with your Firebird database connection details, then run the server using the command ‘npx @modelcontextprotocol/inspector dotnet run’.
Key features
Key features include dynamic query execution in Firebird, support for custom tools, dependency injection, and configuration management through ‘appsettings.json’.
Where to use
MCPServerCSharp can be used in various fields such as database management, application development, and any scenario requiring modular command execution and database interaction.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Content
🛠️ MCP Server with C# + Firebird
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 via
Host.CreateApplicationBuilder - Configuration via
appsettings.json
⚙️ Configuration
Install dependencies by nuget
dotnet add package ModelContextProtocol --prerelease
🔧 appsettings.json File
Create an appsettings.json file in the project root with the following content:
{
"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
[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:
{
"tool": "ListTable",
"args": {
"tableName": "CUSTOMERS",
"filter": "STATUS = 'ACTIVE'",
"limitRecords": 10
}
}Run MCP server
npx @modelcontextprotocol/inspector dotnet run
Dev Tools Supporting MCP
The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.
