Mcp Sqlserver

Created By
bilims10 months ago
Overview

What is MCP SQL Server?

MCP SQL Server is a Model Context Protocol (MCP) server that allows AI agents to interact with Microsoft SQL Server databases, enabling secure and intelligent database operations.

How to use MCP SQL Server?

To use MCP SQL Server, you can run it directly using NPX, install it globally, or build it from source. Configuration is done through a .env file with your SQL Server settings.

Key features of MCP SQL Server?

  • CRUD Operations: Complete functionality for SELECT, INSERT, UPDATE, DELETE.
  • Custom Queries: Safe execution of custom SELECT statements.
  • Schema Introspection: Explore database structures.
  • Stored Procedures: Execute stored procedures with parameters.
  • Transaction Management: Manage transactions with isolation levels.
  • Security: Parameterized queries to prevent SQL injection.

Use cases of MCP SQL Server?

  1. Automating database operations for AI applications.
  2. Managing complex SQL Server transactions.
  3. Performing bulk data operations efficiently.

FAQ from MCP SQL Server?

  • Can MCP SQL Server handle large datasets?

Yes, it supports high-performance bulk operations.

  • Is it secure for production use?

Yes, it includes multiple security features to protect against SQL injection and unauthorized access.

  • What are the prerequisites?

Node.js 20+, TypeScript 5.0+, and Microsoft SQL Server 2016+ are required.

Server Config

{
  "mcpServers": {
    "mcp-sqlserver": {
      "command": "npx",
      "args": [
        "-y",
        "@bilims/mcp-sqlserver"
      ],
      "env": {
        "SQLSERVER_HOST": "your-server-host",
        "SQLSERVER_DATABASE": "your-database",
        "SQLSERVER_USERNAME": "your-username",
        "SQLSERVER_PASSWORD": "your-password"
      }
    }
  }
}
Project Info
Created At
10 months ago
Updated At
10 months ago
Author Name
bilims
Star
-
Language
-
License
-

Recommend Servers

View All
Tavily Mcp
@tavily-ai

JavaScript
a year ago
AI Work Market — USDC settlement rails for AI labor on Base Mainnet)
@Dario (DME)

AI Work Market is a USDC escrow protocol on Base Mainnet, designed for autonomous AI agents to find work, post jobs, and settle payments without humans in the loop. This MCP server exposes 10 tools: **Escrow lifecycle** - `create_intent_quote` — get calldata + gas estimate for funding a new escrow intent - `submit_proof_quote` — get calldata for the seller to submit a proof URI - `release_funds_quote` — get calldata for the buyer to release payment (or claim/refund) **x402 single-call binding** - `x402_consume` — replaces the 5-step x402 flow with one HMAC-signed POST that returns a delivery URL **Onboarding & discovery** - `agent_onboard` — generate a signed agent card with marketplace attestation - `agent_search` — tf-idf search over the live agent catalog - `agent_reputation` — server-side reputation from on-chain Released/Refunded/Disputed events **Live state** - `system_status` — live on-chain state (nextIntentId, accumulatedFees, contract balance, owner) - `escrow_rules` — contract semantics, lifecycle, call guides, failure modes - `events_subscribe` — SSE stream of new on-chain intent events All endpoints are serverless (Vercel) and return their schema on GET. No browser, no wallet UI required for an agent to integrate. The protocol takes a 1% commission on every settlement; the rest goes to the seller. The full AgentCard is at `/.well-known/agent-card.json` (A2A-compatible). The OpenAPI 3.0.3 spec is at `/.well-known/openapi.json` with `components.securitySchemes` (none, hmacX402). `robots.txt` allows GPTBot, ClaudeBot, anthropic-ai, PerplexityBot, Google-Extended, Applebot-Extended, CCBot, Amazonbot.

16 hours ago
Voyei

6 hours ago