$ loading_
Run read-only SQL Server queries and inspect query performance statistics.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "mssql-mcp" yet — see the docs or source repo.
Connect to the company's Microsoft SQL Server and run this read-only query: SELECT TOP 20 order_id, customer_name, total_amount, created_at FROM orders ORDER BY created_at DESC; Return the results in a table.
A structured table showing the 20 most recent order records.
Read-only analyze the performance of this query on Microsoft SQL Server: SELECT customer_id, COUNT(*) AS order_count FROM orders WHERE created_at >= '2024-01-01' GROUP BY customer_id; Provide execution statistics and identify possible performance bottlenecks.
Execution statistics, detected performance issues, and optimization guidance.
Connect to SQL Server and read-only summarize counts and average prices by category in the products table: SELECT category, COUNT(*) AS product_count, AVG(price) AS avg_price FROM products GROUP BY category ORDER BY product_count DESC; Then summarize the key findings.
Category-level statistics plus a brief summary of key data insights.
Safely let AI query MS SQL Server in read-only mode.
Query and manage Microsoft SQL Server databases with natural language.
Securely inspect and query SQL Server databases for analysis and troubleshooting.
Securely connect AI assistants to SQL Server for queries, analysis, and admin tasks.
Safely query multiple SQL databases in read-only mode across servers.
Securely run read-only queries and diagnostics on two SQL Server 2019 instances.