Mcpservercsharp

🚀 MCP Server Using C# and Firebird

This project is a Modular Command Platform (MCP) server that supports custom tools, written in C#. One of its features is the ability to execute dynamic queries in a Firebird database, with filtering and record limits.

🚀 Quick Start

This MCP server allows you to perform dynamic queries in a Firebird database. Below are the steps to get started.

✨ Features

• Support for custom tools in the MCP server.
• Execute dynamic queries in the Firebird database with filtering and record limits.

📦 Installation

Install Dependencies

Use the following command to install the NuGet package:

dotnet add package ModelContextProtocol --prerelease

appsettings.json File

Create an appsettings.json file in the project root directory and add the following content:

{
    "ConnectionStrings": {
        "FirebirdDb": "Database=C:\\yourdata.fdb;User=SYSDBA;Password=masterkey;Dialect=3;Charset=NONE;"
    }
}

📝 Modify C:\\yourdata.fdb according to the actual path of your database file.

📂 Recommended project structure:

src/
├── MCPServer/
│ ├── Factory/
│ │ └── FbConnectionFactory.cs
│ ├── Tools/
│ │ └── FbQueries.cs
│ ├── Program.cs
│ └── appsettings.json

💻 Usage Examples

Basic Usage

ListTable Tool

[McpTool, Description("List all records in a Firebird table")]
public List<Dictionary<string, object>> ListTable(string tableName, string filter = "", int limitRecords = 0)

This tool can return records from a Firebird database table and supports the following functions:

• 🔍 Conditional filtering (via SQL)
• 🔢 Record count limit (using FIRST)

Usage example:

{
    "tool": "ListTable",
    "args": {
        "tableName": "CUSTOMERS",
        "filter": "STATUS = 'ACTIVE'",
        "limitRecords": 10
    }
}

🏡 Run the MCP Server

Use the following command to run the MCP server:

npx @modelcontextprotocol/inspector dotnet run

🔧 Technical Details

Technologies Used