Enterprise SQL & Postgres C# Server

A high-performance C# Model Context Protocol (MCP) server for Microsoft SQL Server and PostgreSQL. Connect Claude Desktop, Cursor IDE, and custom AI workflows to your production databases and filesystems safely, securely, and in under 5 minutes.

---

🔴 The Database Access Problem for AI

AI agents like Claude and Cursor are incredibly smart, but they can't see your data. Giving them direct access to your database is extremely risky:

1. Accidental Deletions/Writes: The AI might generate DROP TABLE, DELETE, or UPDATE commands that corrupt production data.
2. Slow Schema Discovery: Manually copy-pasting tables and structures into prompts is tedious and quickly exceeds context window limits.
3. Runaway Queries: An AI writing a raw SELECT * on a table with 10 million rows will freeze your database server.
4. Path Traversal Attacks: Giving the AI filesystem tools can allow it to escape sandbox limits and read sensitive system files.

---

🟢 The Solution: Hardened C# MCP Server

This C# .NET 8.0 server provides a secure, read-only, and sandboxed bridge:

• Autonomous Schema Crawlers: The AI discovers tables, row counts, columns, primary keys, and types dynamically on-the-fly.
• Automatic Transaction Rollbacks: Every SQL query and stored procedure runs inside an explicit transaction that is automatically rolled back (transaction.Rollback()). Writes are physically impossible.
• Command Keyword Filter: Pre-scans inputs and rejects any command containing modification keywords (INSERT, UPDATE, DELETE, DROP, ALTER, TRUNCATE, EXEC).
• Row Guards: Automatically caps all query outputs with TOP 100 (SQL Server) or LIMIT 100 (PostgreSQL) if no limits are specified.
• Sandboxed Filesystem: Traversal-proof file tools (read, write, copy, move, delete) restricted to a configured sandbox workspace.

---

📦 Getting Started (Trial Guide)

This repository contains the Pre-Compiled Trial Binary of the server.

Step 1: Download & Extract

Clone this repository or download it as a ZIP and extract it to a folder (e.g., C:\Tools\EnterpriseMcpServer).

Step 2: Configure appsettings.json

Open appsettings.json in the extracted folder and configure your SQL database connection strings and sandbox directory:

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=localhost;Database=HeroERP;Trusted_Connection=True;TrustServerCertificate=True;",
    "PostgresConnection": "Host=localhost;Port=5432;Database=HeroERP;Username=postgres;Password=YOUR_PASSWORD;"
  },
  "McpSettings": {
    "AllowedWorkspace": "./Workspace"
  }
}

Step 3: Integrate with Claude Desktop

Open %APPDATA%\Claude\claude_desktop_config.json and register the server:

{
  "mcpServers": {
    "enterprise-sql-filesystem": {
      "command": "dotnet",
      "args": [
        "C:\\Tools\\EnterpriseMcpServer\\bin\\EnterpriseMcpServer.dll"
      ]
    }
  }
}

Note: Make sure to replace C:\\Tools\\EnterpriseMcpServer with your actual absolute path.

Restart Claude. You will see the tools icon (hammer) active, exposing all SQL and sandboxed file tools!

---

🔒 Trial Version vs Full Version

The pre-compiled DLL in this repository is a Trial version. It has a limit of 10 database/file tool calls per session. If exceeded, it asks you to purchase a license.

To download the Full, Unprotected C# Source Code, Visual Studio Solution, and Unlimited Production Build, purchase the toolkit:

👉 Purchase Enterprise AI Toolkit on Gumroad

Includes lifetime updates, commercial use license, and full source code (no obfuscation, no limits).