Microsoft SQL MCP server
Memungkinkan AI client untuk mengeksplorasi skema SQL Server dan menjalankan query SELECT read-only secara aman.
Juga dikenal sebagai bilims/mcp-sqlserver, @bilims/mcp-sqlserver
- Stars
- 47
- Tools
- 8
- Unduhan, 30 hari
- 4.376
- Versi terbaru
- —
- Commit terakhir
- 31 Mar 2026
- Lisensi
- MIT
Apa itu Microsoft SQL MCP?
Microsoft SQL adalah MCP server. Memungkinkan AI client untuk mengeksplorasi skema SQL Server dan menjalankan query SELECT read-only secara aman. Server ini menyediakan 8 tool, seperti list_databases, list_tables, list_views.
Ringkasan dibuat dari README proyek
Tentang Microsoft SQL MCP server
Server ini memungkinkan Anda mengeksplorasi skema Microsoft SQL Server dan menjalankan query read-only langsung dari AI client. Developer dan data analyst dapat berinteraksi dengan Azure SQL Database, on-premises SQL Server, atau instance lokal SQL Server Express menggunakan bahasa natural melalui tool seperti Claude Desktop atau Claude Code CLI. Server ini bekerja dengan cara terhubung ke database Anda melalui environment variables seperti host, user, password, dan nama database.
Keamanan menjadi fokus utama, karena server ini membatasi operasi hanya pada statement SELECT read-only untuk mencegah modifikasi data yang tidak disengaja. Server ini dilengkapi perlindungan bawaan terhadap SQL injection dan menggunakan blacklist untuk memblokir keyword berbahaya seperti INSERT atau DELETE. Anda dapat menemukan struktur database menggunakan tool seperti list_tables, describe_table, dan get_foreign_keys. Untuk pengambilan data, tool execute_query memungkinkan eksplorasi yang aman dengan limit baris dan timeout yang dapat dikonfigurasi guna memastikan stabilitas saat menjalankan query yang kompleks.
Apa yang bisa Anda lakukan dengannya
- 1Eksplorasi struktur databaseMinta AI untuk mengidentifikasi semua tabel dan definisi kolom di dalam skema database tertentu.
- 2Analisis relasi tabelMinta ringkasan tentang bagaimana berbagai tabel terhubung melalui foreign keys.
- 3Mengambil sampel dataGunakan bahasa natural untuk mengambil sejumlah terbatas record dari tabel tertentu untuk inspeksi.
- 4Audit ukuran tabelIdentifikasi tabel mana dalam database yang menggunakan ruang paling besar atau berisi baris terbanyak.
Ditulis berdasarkan README proyek. Setiap use case diperiksa terhadap kutipan dari README tersebut.
Cara menginstal Microsoft SQL MCP
Format diverifikasi 10 Nov 2026Tambahkan ke CursorTambahkan ke GooseInstal Microsoft SQL MCP di Claude Code
$ claude mcp add mcp-sqlserver -- npx -y @bilims/mcp-sqlserverInstal Microsoft SQL MCP di Cursor
~/.cursor/mcp.json
{
"mcpServers": {
"mcp-sqlserver": {
"command": "npx",
"args": [
"-y",
"@bilims/mcp-sqlserver"
]
}
}
}Instal Microsoft SQL MCP di VS Code
.vscode/mcp.json
{
"servers": {
"mcp-sqlserver": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@bilims/mcp-sqlserver"
]
}
}
}Instal Microsoft SQL MCP di VS Code CLI
$ code --add-mcp '{"name":"mcp-sqlserver","type":"stdio","command":"npx","args":["-y","@bilims/mcp-sqlserver"]}'Instal Microsoft SQL MCP di Claude Desktop
claude_desktop_config.json
{
"mcpServers": {
"mcp-sqlserver": {
"command": "npx",
"args": [
"-y",
"@bilims/mcp-sqlserver"
]
}
}
}Instal Microsoft SQL MCP di Codex
$ codex mcp add mcp-sqlserver -- npx -y @bilims/mcp-sqlserverInstal Microsoft SQL MCP di Codex config.toml
~/.codex/config.toml
[mcp_servers.mcp-sqlserver] command = "npx" args = ["-y", "@bilims/mcp-sqlserver"]
Instal Microsoft SQL MCP di Gemini CLI
$ gemini mcp add -s user mcp-sqlserver npx -- -y @bilims/mcp-sqlserverInstal Microsoft SQL MCP di Gemini settings.json
~/.gemini/settings.json
{
"mcpServers": {
"mcp-sqlserver": {
"command": "npx",
"args": [
"-y",
"@bilims/mcp-sqlserver"
]
}
}
}Tool Microsoft SQL MCP 8
Terdeteksi dari READMElist_databaseslist_tableslist_viewsdescribe_tableget_foreign_keysget_table_statsexecute_queryget_server_info
| list_databases | — | |
| list_tables | — | |
| list_views | — | |
| describe_table | — | |
| get_foreign_keys | — | |
| get_table_stats | — | |
| execute_query | — | |
| get_server_info | — |
Konfigurasi
SQLSERVER_DATABASESQLSERVER_ENCRYPTSQLSERVER_HOSTSQLSERVER_PASSWORDSQLSERVER_TRUST_CERTSQLSERVER_USER
| Nama | Deskripsi | Tipe |
|---|---|---|
| SQLSERVER_DATABASE | — | |
| SQLSERVER_ENCRYPT | — | |
| SQLSERVER_HOST | — | |
| SQLSERVER_PASSWORD | — | |
| SQLSERVER_TRUST_CERT | — | |
| SQLSERVER_USER | — |
Pengecekan otomatis
Berjalan 14 Nov 2026Laporan lengkap →Belum diverifikasi. Sebuah server memerlukan skor 80, tidak ada temuan serius, dan data yang cukup untuk kami periksa. Cara kerja checks · Yang perlu diperbaiki untuk menambah poin
- Source repository terhubung dan dapat dijangkaubilims/mcp-sqlserver is public and reachablegithub.com/bilims/mcp-sqlserver ↗Lolos
- Nama paket mencantumkan repositori ini sebagai sumbernya@bilims/mcp-sqlserver names bilims/mcp-sqlserver as sourcenpmjs.com/package/@bilims/mcp-sqlserver ↗Lolos
- Provenance build (atestasi Sigstore)No build attestation published for this releaseTidak diperiksa
- Lisensi open source (OSI)MITspdx.org/licenses/MIT.html ↗Lolos
- Ada commit atau release dalam satu tahun terakhirLast commit or release 2026-03-31github.com/bilims/mcp-sqlserver ↗Lolos
- OpenSSF ScorecardTidak diperiksa
- Nama package tidak mirip dengan package populerNo popular package one edit away from @bilims/mcp-sqlserverLolos
- Tidak ada advisory kritis pada paket atau dependensinyaTidak diperiksa
- Tidak ada instruksi tersembunyi untuk model8 tool descriptions and the README read; no override phrases, credential paths or hidden charactersLolos
- Tools yang bersifat destruktif telah diberi labelTidak diperiksa
- Endpoint remote merespons handshake MCPTidak diperiksa
README
Lihat di GitHubMCP SQL Server
A read-only Model Context Protocol (MCP) server for Microsoft SQL Server that enables AI agents to safely explore and query SQL Server databases.
Quick Start
Step 1: Install the Package
# Global installation (recommended)
npm install -g @bilims/mcp-sqlserver
# Verify installation
mcp-sqlserver --version
Step 2: Configure Your SQL Server Connection
Choose your SQL Server type and follow the configuration:
Azure SQL Database
export SQLSERVER_HOST="your-server.database.windows.net"
export SQLSERVER_USER="your-username"
export SQLSERVER_PASSWORD="your-password"
export SQLSERVER_DATABASE="your-database"
export SQLSERVER_ENCRYPT="true"
export SQLSERVER_TRUST_CERT="false"
On-Premises SQL Server
export SQLSERVER_HOST="your-sql-server.company.com"
export SQLSERVER_USER="your-username"
export SQLSERVER_PASSWORD="your-password"
export SQLSERVER_DATABASE="your-database"
export SQLSERVER_ENCRYPT="true"
export SQLSERVER_TRUST_CERT="true" # For self-signed certificates
Local SQL Server Express
export SQLSERVER_HOST="localhost\\SQLEXPRESS"
export SQLSERVER_USER="sa"
export SQLSERVER_PASSWORD="your-password"
export SQLSERVER_DATABASE="master"
export SQLSERVER_ENCRYPT="false"
export SQLSERVER_TRUST_CERT="true"
Step 3: Test the Connection
# Test your configuration
mcp-sqlserver --help
# Quick connection test (press Ctrl+C to exit)
mcp-sqlserver
Step 4: Add to Claude Desktop
-
Find your Claude Desktop config file:
- macOS:
~/Library/Application Support/Claude/claude_desktop_config.json - Windows:
%APPDATA%\Claude\claude_desktop_config.json
- macOS:
-
Add the MCP server configuration:
{
"mcpServers": {
"sqlserver": {
"command": "mcp-sqlserver",
"env": {
"SQLSERVER_HOST": "your-server.database.windows.net",
"SQLSERVER_USER": "your-username",
"SQLSERVER_PASSWORD": "your-password",
"SQLSERVER_DATABASE": "your-database",
"SQLSERVER_ENCRYPT": "true",
"SQLSERVER_TRUST_CERT": "false"
}
}
}
}
- Restart Claude Desktop
Step 5: Start Exploring!
Try these commands in Claude Desktop:
"Test the SQL Server connection""List all databases on the server""Show me the tables in [database name]""Describe the structure of the Users table""Show me foreign key relationships"
Features
- 🔒 Read-only operations: Only SELECT queries allowed, with comprehensive security validation
- 🗄️ Schema discovery: Explore databases, tables, views, relationships, and metadata
- 📊 Data exploration: Execute safe queries with built-in limits and timeouts
- 🔐 Enterprise-ready: Encrypted connections with certificate trust for production environments
- 🛡️ Security-first: Query validation, SQL injection protection, and access controls
Available Tools
Schema Discovery
list_databases- List all databases on the SQL Server instancelist_tables- List tables in a database or schemalist_views- List views in a database or schemadescribe_table- Get detailed table schema including columns, data types, and constraints
Relationship Analysis
get_foreign_keys- Get foreign key relationships for tablesget_table_stats- Get table statistics including row counts and size information
Data Exploration
execute_query- Execute read-only SELECT queries with safety validationget_server_info- Get SQL Server version, edition, and configuration details
Common Commands for Claude Desktop
Once your MCP server is configured, try these natural language commands:
Getting Started Commands
"Test the SQL Server connection"
"Show me server information"
"List all databases on this server"
"What tables are in the [database name] database?"
Database Exploration
"Describe the structure of the Users table"
"Show me foreign key relationships in this database"
"What are the largest tables by row count?"
"Give me a sample of data from the Orders table"
Advanced Analysis
"Help me understand the relationship between Orders and Customers"
"Show me all lookup tables in this database"
"What columns contain date/time information?"
"Find tables that might contain user authentication data"
Custom Queries
"Run this query: SELECT TOP 10 * FROM Products WHERE Price > 100"
"Show me all customers created in the last 30 days"
"What are the different product categories in the database?"
Installation
npm install
npm run build
Configuration
The server is configured using environment variables:
Required
SQLSERVER_USER- SQL Server usernameSQLSERVER_PASSWORD- SQL Server password
Optional
SQLSERVER_HOST- Server hostname (default: localhost)SQLSERVER_DATABASE- Default database nameSQLSERVER_PORT- Port number (default: 1433)SQLSERVER_ENCRYPT- Enable encryption (default: true)SQLSERVER_TRUST_CERT- Trust server certificate (default: true)SQLSERVER_CONNECTION_TIMEOUT- Connection timeout in ms (default: 30000)SQLSERVER_REQUEST_TIMEOUT- Request timeout in ms (default: 60000)SQLSERVER_MAX_ROWS- Maximum rows per query (default: 1000)
Usage
Environment Variables
export SQLSERVER_HOST="your-server.database.windows.net"
export SQLSERVER_USER="your-username"
export SQLSERVER_PASSWORD="your-password"
export SQLSERVER_DATABASE="your-database"
export SQLSERVER_ENCRYPT="true"
export SQLSERVER_TRUST_CERT="true"
Running the Server
npm start
Installation Options
Option 1: Global Installation (Recommended)
npm install -g @bilims/mcp-sqlserver
Option 2: Local Installation
npm install @bilims/mcp-sqlserver
npx mcp-sqlserver
Option 3: Run with npx (No Installation)
npx @bilims/mcp-sqlserver
Integration Examples
Claude Desktop
Add to your Claude Desktop configuration (claude_desktop_config.json):
{
"mcpServers": {
"sqlserver": {
"command": "mcp-sqlserver",
"env": {
"SQLSERVER_HOST": "your-server.database.windows.net",
"SQLSERVER_USER": "your-username",
"SQLSERVER_PASSWORD": "your-password",
"SQLSERVER_DATABASE": "your-database"
}
}
}
}
Claude Code CLI
# Set environment variables
export SQLSERVER_HOST="your-server"
export SQLSERVER_USER="your-username"
export SQLSERVER_PASSWORD="your-password"
# Use with Claude Code
claude mcp add sqlserver mcp-sqlserver
VSCode with MCP Extension
Install the MCP extension for VSCode and add the server configuration.
Security Features
Query Validation
- Only SELECT, WITH, SHOW, DESCRIBE, and EXPLAIN statements allowed
- Comprehensive blacklist of dangerous keywords (INSERT, UPDATE, DELETE, DROP, etc.)
- SQL injection pattern detection
- Automatic query sanitization
Connection Security
- TLS/SSL encryption enabled by default
- Server certificate trust options for enterprise environments
- Connection pooling with timeout controls
- Configurable request timeouts
Result Limits
- Maximum row limits per query (configurable)
- Automatic TOP clause injection for SELECT queries
- Query execution time tracking
- Memory usage protection
Example Queries
Once connected, you can use the tools through your MCP client:
// List all databases
await callTool("list_databases", {});
// List tables in a specific schema
await callTool("list_tables", { schema: "dbo" });
// Get table schema details
await callTool("describe_table", {
table_name: "Users",
schema: "dbo"
});
// Execute a read-only query
await callTool("execute_query", {
query: "SELECT TOP 10 * FROM Users WHERE active = 1",
limit: 10
});
// Get foreign key relationships
await callTool("get_foreign_keys", {
table_name: "Orders"
});
Development
# Install dependencies
npm install
# Build the project
npm run build
# Run in development mode
npm run dev
# Run linting
npm run lint
# Run tests
npm test
Troubleshooting
Connection Issues
- Verify server hostname and port
- Check if encryption/certificate settings match your SQL Server configuration
- Ensure user has appropriate read permissions
- Test connection using SQL Server Management Studio first
Permission Issues
The user account needs at minimum:
CONNECTpermission to the databaseSELECTpermission on tables/views you want to query- Access to system views for metadata queries
Common SQL Server Configurations
Azure SQL Database
export SQLSERVER_HOST="your-server.database.windows.net"
export SQLSERVER_ENCRYPT="true"
export SQLSERVER_TRUST_CERT="false"
On-premises SQL Server with self-signed certificates
export SQLSERVER_HOST="sql-server.company.com"
export SQLSERVER_ENCRYPT="true"
export SQLSERVER_TRUST_CERT="true"
License
MIT
Contributing
- Fork the repository
- Create a feature branch
- Make your changes
- Add tests if applicable
- Submit a pull request
Support
For issues and questions:
- Check the troubleshooting section above
- Review SQL Server connection documentation
- Ensure MCP client compatibility
Built with the Model Context Protocol SDK for seamless AI integration.
Pertanyaan tentang Microsoft SQL MCP
Bagaimana cara menambahkan Microsoft SQL MCP ke Claude Code?
Jalankan claude mcp add mcp-sqlserver -- npx -y @bilims/mcp-sqlserver di terminal Anda. Tambahkan --scope user agar tersedia di semua proyek.
Bagaimana cara menambahkan Microsoft SQL MCP ke Cursor?
Buka ~/.cursor/mcp.json dan tambahkan server di bawah mcpServers, menggunakan config Cursor yang ditunjukkan di bagian instalasi di atas.
Tool apa yang disediakan Microsoft SQL MCP?
Server ini menyediakan 8 tool, termasuk list_databases, list_tables, list_views, describe_table, get_foreign_keys.
Apakah MCP server ini bisa mengubah atau menghapus data di SQL Server?
Tidak, server ini bersifat read-only: hanya statement SELECT, WITH, SHOW, DESCRIBE, dan EXPLAIN yang diizinkan, serta keyword berbahaya telah masuk dalam blacklist.
Bagaimana cara mengonfigurasi koneksi SQL Server?
Atur environment variables seperti SQLSERVER_HOST, SQLSERVER_USER, SQLSERVER_PASSWORD, dan SQLSERVER_DATABASE, serta opsi enkripsi.
Tool apa saja yang disediakan server untuk discovery skema?
Server ini menyediakan list_databases, list_tables, list_views, dan describe_table, serta tool untuk relationship dan query.
Apakah ini berfungsi dengan Azure SQL Database?
Ya, dengan mengaktifkan enkripsi dan menonaktifkan certificate trust untuk setup Azure.
Berapa banyak baris yang bisa dikembalikan oleh sebuah query?
Jumlah baris dibatasi per query melalui SQLSERVER_MAX_ROWS, yang secara default bernilai 1000.