Korean | 한국어

개요

MSSQL의 MCP Server는 데이터베이스 상호 작용 및 비즈니스 인텔리전스 기능을 제공합니다. 이 서버는 SQL 쿼리를 실행하고 비즈니스 데이터를 분석하고 비즈니스 통찰력 메모를 자동으로 생성 할 수 있습니다. MSSQL에 맞게 수정을위한 공식 웹 사이트 SQLite에 대한 참조.

MCP 2025-06-18 사양을 지원하는 공식 MCP Python SDK (FastMCP)에 내장되어 있습니다. 구조화 된 도구 출력 (structuredContent), 도구 annotations, 리소스 템플릿 및 elicitation 기반 쓰기 확인.

주요 특징:

• Multi-database - 한 서버에서 마운트 dev/staging/prod 연결; 모든 도구는 옵션이 걸립니다 database 매개 변수, 자체와 각 연결 readonly / query_timeout] / max_rows / confirm_writes] 설정
• Stored Procedure - 목록 서명 및 전체 멀티-result-set 수확 절차 수행 -Resource Templates — schema://{database}/{schema}/{table}]는 각 턴 툴-schema 토큰을 점화하지 않고 수요에 대한 테이블 구조를 제공합니다 -Safety guardrails — SQL whitelisting, read-only mode, row limits, query timeouts, write하기 전에 선택적인 elicitation 확인

부품

• [T7]]

MSSQL MCP Server

English | 中文

Overview

MSSQL MCP Server, provides database interaction and business intelligence capabilities. This server enables running SQL queries, analyzing business data, and automatically generating business insight memos.
Refer to the official website’s SQLite for modifications to adapt to MSSQL.

Built on the official MCP Python SDK (FastMCP), supporting the MCP 2025-06-18 specification: structured tool output (structuredContent), tool annotations, resource templates, and elicitation-based write confirmation.

Highlights:

• Multi-database — mount dev/staging/prod connections in one server; every tool takes an optional database parameter, each connection with its own readonly / query_timeout / max_rows / confirm_writes settings
• Stored procedures — list signatures and execute procedures with full multi-result-set harvesting
• Resource templates — schema://{database}/{schema}/{table} serves table structures on demand without burning tool-schema tokens every turn
• Safety guardrails — SQL whitelisting, read-only mode, row limits, query timeouts, optional elicitation confirmation before writes

Components

• read_query
  • Execute SELECT / WITH queries with structured output (columns / rows / row_count / truncated), limited by max_rows
• write_query
  • Execute INSERT, UPDATE, DELETE or MERGE queries, returns affected row count
• create_table
  • Create new tables in the database
• list_tables
  • Get a list of all tables in the database (schema + table name)
• list_views
  • Get a list of all views in the database
• describe_table
  • View full schema for a specific table (type, nullable, default, primary key, identity, foreign keys, indexes)
• list_databases
  • List configured database connections (name, readonly, is_default)
• list_procedures
  • List stored procedures with parameter signatures
• execute_procedure
  • Execute a stored procedure (supports multiple result sets)
• append_insight
  • Add new business insights to the memo resource

Resources

• memo://insights — a living business-insights memo, updated in real time via append_insight
• schema://{schema}/{table} — table structure of the default database (JSON: columns / PK / identity / FKs / indexes)
• schema://{database}/{schema}/{table} — table structure of a named database connection

Resource templates are fetched on demand: unlike tool schemas they are not resent to the LLM every turn, which keeps long conversations lean.

Security

All SQL goes through static validation before execution:

• read_query only accepts a single SELECT / WITH statement and rejects any write or EXEC keyword (blocks e.g. WITH c AS (...) DELETE FROM t)
• write_query uses a whitelist (INSERT / UPDATE / DELETE / MERGE only); EXEC, DROP, TRUNCATE, ALTER are rejected
• Multi-statement batches (separated by ;) are rejected