MCP Servers

SQL Server MCP Server

Enables AI agents to interact with SQL Server databases for debugging and data issue resolution, providing tools for query execution, schema inspection, and diagnostics.

README

SQL Server MCP Server

A Model Context Protocol (MCP) server for SQL Server — built for development debugging and data issue resolution. Connects to Antigravity (the AI agent) so you can diagnose and fix data problems directly from your IDE chat.

🚀 Setup & Configuration

Configure the server directly inside your Antigravity (or any MCP client) configuration using environment variables:

{
  "mcpServers": {
    "sql-server-mcp": {
      "command": "npx",
      "args": ["-y", "@dkp5897/sql-server-mcp"],
      "env": {
        "DB_SERVER": "localhost",
        "DB_NAME": "YourDatabaseName",
        "DB_USER": "sa",
        "DB_PASSWORD": "your_password",
        "DB_PORT": "1433",
        "DB_TRUST_CERT": "true"
      }
    }
  }
}

Environment Variables Reference

Variable	Description	Default
`DB_SERVER` / `SQL_SERVER`	SQL Server host / instance name	`localhost`
`DB_NAME` / `SQL_DATABASE`	Database name	`master`
`DB_USER` / `SQL_USER`	SQL Server username	`sa`
`DB_PASSWORD` / `SQL_PASSWORD`	SQL Server password	`""`
`DB_PORT` / `SQL_PORT`	SQL Server port	`1433`
`DB_TRUST_CERT` / `SQL_TRUST_CERT`	Trust self-signed certificate	`true`
`DB_ENCRYPT`	Enable TLS encryption	`false`

🛠️ Available Tools (13 total)

Query Execution

Tool	Description
`sql_run_query`	Run a SELECT query — executes immediately
`sql_run_write`	Run INSERT/UPDATE/DELETE/DDL — shows preview first, requires confirm=true to execute

Schema Inspection

Tool	Description
`sql_list_tables`	List all tables (with row counts)
`sql_inspect_table`	Full table details: columns, PKs, FKs, indexes
`sql_list_stored_procs`	List all stored procedures
`sql_get_stored_proc_def`	Get the source code of a stored procedure

Data Diagnostics

Tool	Description
`sql_find_data`	Search for a value across all columns in a table
`sql_check_foreign_keys`	Find orphaned records / FK violations
`sql_count_and_sample`	Row count + sample rows from a table
`sql_check_nulls`	Find NULL values in specified columns
`sql_compare_counts`	Compare parent/child table counts to find gaps
`sql_diagnose_issue`	Full diagnostic report on a table
`sql_get_query_plan`	Get execution plan for a slow query

🔐 Permission Model

Query Type	Behaviour
`SELECT`	Runs immediately, no confirmation needed
`INSERT / UPDATE / DELETE`	Shows preview first. Must call again with `confirm: true`
`DROP TABLE / ALTER / CREATE`	Shows preview first. Must call again with `confirm: true`
`DROP DATABASE / xp_cmdshell / BULK INSERT`	Always blocked, cannot be executed

💡 Example Questions to Ask the Agent

"List all tables in the database"
"Inspect the Orders table"
"Find all rows in OrderItems where ProductId is NULL"
"Are there any foreign key violations in the Payments table?"
"Show me 10 sample rows from Customers where IsActive = 0"
"Run a full diagnostic on the Orders table"
"Update the 3 orders with NULL CustomerId — set them to CustomerId = 1"

📦 Publishing to npm

To publish your own version to npm:

npm login
npm publish --access public

Recommended Servers

playwright-mcp

A Model Context Protocol server that enables LLMs to interact with web pages through structured accessibility snapshots without requiring vision models or screenshots.

Official

Featured

TypeScript

Magic Component Platform (MCP)

An AI-powered tool that generates modern UI components from natural language descriptions, integrating with popular IDEs to streamline UI development workflow.

Audiense Insights MCP Server

Enables interaction with Audiense Insights accounts via the Model Context Protocol, facilitating the extraction and analysis of marketing insights and audience data including demographics, behavior, and influencer engagement.

VeyraX MCP

Single MCP tool to connect all your favorite tools: Gmail, Calendar and 40 more.

Official

Featured

Local

graphlit-mcp-server

The Model Context Protocol (MCP) Server enables integration between MCP clients and the Graphlit service. Ingest anything from Slack to Gmail to podcast feeds, in addition to web crawling, into a Graphlit project - and then retrieve relevant contents from the MCP client.

Official

Featured

TypeScript

Kagi MCP Server

An MCP server that integrates Kagi search capabilities with Claude AI, enabling Claude to perform real-time web searches when answering questions that require up-to-date information.

Official

Featured

Python

E2B

Using MCP to run code via e2b.

Official

Featured

Neon Database

MCP server for interacting with Neon Management API and databases

Official

Featured

Exa Search

A Model Context Protocol (MCP) server lets AI assistants like Claude use the Exa AI Search API for web searches. This setup allows AI models to get real-time web information in a safe and controlled way.

Official

Featured

Qdrant Server

This repository is an example of how to create a MCP server for Qdrant, a vector search engine.

Official

Featured