MSSQL MCP Server

Created By
daobataotiea year ago
mssql mcp server
Overview

what is MSSQL MCP Server?

MSSQL MCP Server is a database interaction and business intelligence tool that allows users to run SQL queries, analyze business data, and automatically generate business insight memos.

how to use MSSQL MCP Server?

To use MSSQL MCP Server, install the required packages, configure the database connection in a JSON file, and run the server script to interact with the database.

key features of MSSQL MCP Server?

  • Execute SELECT, INSERT, UPDATE, and DELETE SQL queries.
  • Create and manage database tables.
  • Generate business insights and memos automatically.
  • Supports ODBC Driver for SQL Server.

use cases of MSSQL MCP Server?

  1. Analyzing business data for decision-making.
  2. Automating the generation of business reports.
  3. Managing and querying large datasets in SQL Server.

FAQ from MSSQL MCP Server?

  • What programming language is MSSQL MCP Server built with?

MSSQL MCP Server is built with Python.

  • Is there a license for MSSQL MCP Server?

Yes, it is released under the MIT License.

  • What are the system requirements?

It requires Python 3.x and specific packages like pyodbc and pydantic.

Project Info
Created At
a year ago
Updated At
a year ago
Author Name
daobataotie
Star
31
Language
Python
License
MIT license
Tags

Recommend Servers

View All
Voyei

3 hours 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.

13 hours ago