SQL Server

Connect to Microsoft SQL Server database to query and manage data.

Key Features

• Execute T-SQL queries
• Query database schema
• Manage tables and data
• Execute stored procedures
• Real-time data analysis
• Read-only mode support

Basic Information

Authentication Method

Authenticate using username/password.

Input Parameters

• Host (required): SQL Server host
• Port (required): SQL Server port (default: 1433)
• Username (required): SQL Server username
• Password (required): SQL Server password
• Database (optional): Database name to connect to (default: master)
• Connection Timeout (optional): Connection timeout (default: 30000ms, max: 60000ms)
• Use SSL (optional): Whether to use SSL connection
• Read Only (optional): Whether to enable read-only mode

Supported MCP Tools

execute_sql

Execute T-SQL queries on SQL Server database and return results.

In read-only mode, only the following SQL commands are allowed:

• SELECT - Query data
• WITH - Use Common Table Expression (CTE)
• EXPLAIN - Query execution plan
• ANALYZE - Query analysis
• SHOW - Metadata queries

Result Limit: Returns a maximum of 500 rows for performance reasons.

For example,

• When you input “Query the user table data” as a prompt,
• The LLM executes the SELECT * FROM users query through MCP.
• Then, it responds in the chat based on the tool call results.

SQL Server Connection Setup

1. Prepare a user account that can access SQL Server.
2. Grant necessary database permissions.
3. Configure network access permissions.
4. Select SQL Server integration in QueryPie AI.
5. Enter connection information to complete the setup.

Precautions

• Keep your SQL Server user account password secure.
• It’s recommended to grant only the minimum necessary database permissions.
• It’s recommended to use SSL connections in production environments.
• Large query results are limited to 500 rows, so use appropriate TOP clauses.
• You can prevent data changes by enabling read-only mode.