SQL Server
About
Provides a bridge to Microsoft SQL Server databases for executing queries, exploring schemas, and managing data through natural language interaction with Windows authentication security
Details
- Author
- dennismartis
- Repository
- dennismartis/sql_mcp_server
- Categories
- AI, Design, Developer Tools, Search, Frontend, Security
- Tags
- #integration
Jump to
- Execute SQL queries and view results
- List available tables in the database
- Describe table structure with column information
- Execute non-query operations (INSERT, UPDATE, DELETE)
- List available ODBC drivers on the system
- View database information and server details
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
SQL ServerCommand (node, npx, python, etc.)npxArguments-
Argument 1
-y -
Argument 2
@highlight/mcp-server
Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
-
Argument 1
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Run the server:
python mcp_sql_server.py
The server will initialize and establish a connection to the specified SQL Server database.
query_sql
Execute a SQL query and return the results. Parameters: query (string, optional; defaults to 'SELECT * FROM [dbo].[Table_1]')
list_tables
List all tables available in the database. Returns a list of table names as a string.
describe_table
Get the structure of a specific table. Parameters: table_name (string; the name of the table to describe). Returns column information including names and data types.
execute_nonquery
Execute INSERT, UPDATE, DELETE or other non-query SQL statements. Parameters: sql (string; the SQL statement to execute). Returns operation results, including number of affected rows.
list_odbc_drivers
List all available ODBC drivers on the system. Returns a comma-separated list of installed ODBC drivers.
database_info
Get general information about the connected database. Returns server name, database name, SQL Server version, current server time, and table count.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"sql server": {
"env": {},
"args": [
"-y",
"@highlight/mcp-server"
],
"command": "npx"
}
}
}Linux
{
"env": [],
"args": [
"-y",
"@highlight/mcp-server"
],
"command": "npx"
}Macos
{
"env": [],
"args": [
"-y",
"@highlight/mcp-server"
],
"command": "npx"
}Windows
{
"env": [],
"args": [
"/c",
"npx",
"-y",
"@highlight/mcp-server"
],
"command": "cmd"
}MCP SQL Server
A FastMCP server that provides SQL database interaction tools via a conversational AI interface.
Overview
This project creates a server that exposes MS SQL Server operations through a conversational AI interface. It uses the FastMCP framework to provide tools for querying and manipulating SQL data, allowing users to interact with databases using natural language.
Features
- Execute SQL queries and view results
- List available tables in the database
- Describe table structure with column information
- Execute non-query operations (INSERT, UPDATE, DELETE)
- List available ODBC drivers on the system
- View database information and server details
Requirements
- Python 3.7+
- pyodbc
- asyncio
- FastMCP framework
- Microsoft SQL Server
- ODBC Driver 17 for SQL Server
Installation
1. Install Python dependencies:
pip install pyodbc asyncio fastmcp
2. Ensure you have Microsoft SQL Server installed and the ODBC Driver 17 for SQL Server.
3. Configure the connection settings in the script:
```python
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
