SQL MCP Server provides a bridge between AI assistants and Microsoft SQL Server databases, enabling natural language interaction for querying and manipulating data. Built with FastMCP and pyodbc, it exposes tools for executing SQL queries, listing tables, describing schemas, and managing database operations through an asynchronous architecture that prevents blocking. The implementation features comprehensive error handling, Windows authentication security, and is particularly valuable for database administrators and analysts who need to interact with SQL Server through conversational AI.
Aucun avis encore. Soyez le premier à donner votre avis !
Connectez-vous pour rejoindre la conversation
Execute a SQL query and return the results. Parameters: query (string) - If no query is provided, it defaults to `SELECT * FROM [dbo].[Table_1]`. Returns query results as a formatted string.
List all tables available in the database. Returns a list of table names as a string.
Get the structure of a specific table. Parameters: table_name (string) - Name of the table to describe. Returns column information including names and data types.
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. Automatically handles transactions (commit/rollback).
List all available ODBC drivers on the system. Returns a comma-separated list of installed ODBC drivers.
Get general information about the connected database. Returns server name, database name, SQL Server version, current server time, and table count.
