MS SQL MCP Server 1.1

The bundled client provides an easy menu-driven interface:

1. List available resources - See what information is available
2. List available tools - See what actions you can perform
3. Execute SQL query - Run a read-only SQL query
4. Get table details - View structure of any table
5. Read database schema - See all tables and their relationships
6. Generate SQL query - Convert natural language to SQL

The MCP server supports SQL Server-specific features:

- Common Table Expressions (CTEs)
- Window functions
- JSON operations
- Hierarchical queries
- Full-text search (when configured in your database)

- Read-only by default: No risk of data modification
- Private credentials: Database connection details stay in your .env file
- SQL injection protection: Built-in validation for SQL queries

Step 1: Install Prerequisites

This tool allows AI assistants to:
1. Discover tables in your SQL Server database
2. View table structures (columns, data types, etc.)
3. Execute read-only SQL queries safely
4. Generate SQL queries from natural language requests

When working with Claude or other AI assistants through this MCP server, the way you phrase your requests significantly impacts the results. Here's how to help the AI use the database tools effectively:

When prompting an AI to use this tool, follow this structure:

Can you use the SQL MCP tools to [your goal]?
For example:

- Check what tables exist in my database

- Query the Customers table and show me the first 10 records

- Find all orders from the past month

If the AI uses incorrect syntax, you can help it with:

That's not quite right. Please use this format for the tool call:
mcp_SQL_mcp_execute_query({ 
  sql: "SELECT * FROM Customers WHERE Region = 'West'",
  returnResults: true
})

- Registers all database tools with the MCP server
- Implements tool validation and parameter checking
- Provides core functionality for SQL queries, table exploration, and database discovery
- Maps tool calls to database operations