Inspect SQL Server schemas, run safe read-only queries, and analyze query plans.
Copy the install command and let the AI configure it · recommended for beginners
Please install the "io.github.Nithish1206/SqlServerMcp" MCP server from askskill: Run: claude mcp add 'io-github-nithish1206-sqlservermcp' -- npx -y SqlServerMcp
Connect to SQL Server and list all tables, column types, primary keys, and indexes in the current database, grouped by schema.
A structured inventory of database metadata to understand table structures and index design.
Run a read-only query on sales.orders to calculate daily order counts and total sales for the last 30 days, sorted by date ascending, without performing any write operations.
A result table with the last 30 days of order statistics, ready for analysis or reporting.
Analyze the execution plan for the following SQL query, identify possible performance bottlenecks, and suggest practical indexing or query rewrite improvements: SELECT * FROM orders WHERE customer_id = 1001 AND order_date >= '2024-01-01';
An execution plan interpretation, bottleneck diagnosis, and concrete performance optimization recommendations.
Use natural-language prompts to inspect SQL Server schemas and perform CRUD operations via MCP tools.
Explore SQL Server and PostgreSQL databases with read-only SELECT queries.
Query and manage Microsoft SQL Server databases with natural language.
Safely let AI agents explore and query SQL Server databases read-only.
Query SQL Server data in natural language through read-only MCP access.
Access multiple SQL databases with schema discovery, caching, and safety controls.