SQL MCP Server
Click on "Install Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@SQL MCP Servershow me the top 10 customers by total purchases"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
SQL MCP Server
A Model Context Protocol (MCP) server implementation for SQL databases, providing a standardized interface for interacting with SQL databases through the MCP protocol.
Installation
{
"mcpServers": {
"sql-mcp": {
"command": "npx",
"args": ["@adetxt/sql-mcp"]
}
}
}{
"mcpServers": {
"sql-mcp": {
"command": "npx",
"args": ["@adetxt/sql-mcp"]
}
}
}{
"mcp": {
"servers": {
"sql-mcp": {
"type": "stdio",
"command": "npx",
"args": ["@adetxt/sql-mcp"]
}
}
}Related MCP server: SQLite MCP Server
License
MIT
Contributing
Contributions are welcome! Please feel free to submit a Pull Request.
Support
For support, please open an issue in the GitHub repository.
Available Tools
3 toolsexecute_queryExecute QueryC
Run a query to database
| Name | Required | Description | Default |
|---|---|---|---|
| db_type | Yes | ||
| connection_string | Yes | ||
| query | Yes |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations are provided, so the description carries the full burden of behavioral disclosure. 'Run a query to database' implies a potentially mutating operation (e.g., INSERT, UPDATE, DELETE) but doesn't specify if it's read-only, destructive, requires authentication, has rate limits, or what the output format is. This is a significant gap for a tool with no annotation coverage.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is extremely concise with a single sentence 'Run a query to database', which is front-loaded and wastes no words. It efficiently conveys the core action, though this brevity contributes to gaps in other dimensions.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the complexity (a database query tool with potential mutations), no annotations, no output schema, and 0% schema coverage, the description is incomplete. It doesn't address key aspects like safety, return values, or parameter details, making it insufficient for effective tool use.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema description coverage is 0%, meaning parameters (db_type, connection_string, query) are undocumented in the schema. The description adds no meaning beyond the schema, failing to explain what these parameters do, their formats, or examples. For a tool with 3 parameters and low coverage, this is inadequate.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description 'Run a query to database' states the action (run/execute) and resource (database query), which clarifies the basic purpose. However, it's vague about what type of query (e.g., SELECT, INSERT, UPDATE) and lacks distinction from sibling tools like get_columns or get_tables, which might also involve database queries but for specific purposes.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides no guidance on when to use this tool versus alternatives. It doesn't mention sibling tools (get_columns, get_tables) or specify contexts like executing arbitrary SQL versus retrieving metadata, leaving the agent with no usage instructions beyond the basic action.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
get_columnsGet ColumnsC
Get list of column in a table
| Name | Required | Description | Default |
|---|---|---|---|
| db_type | Yes | ||
| connection_string | Yes | ||
| table_name | Yes |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
No annotations are provided, so the description carries the full burden of behavioral disclosure. However, it only states the action without revealing any behavioral traits such as read-only vs. destructive nature, authentication needs, rate limits, or output format. This is inadequate for a tool that interacts with databases, where such details are critical.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is a single, efficient sentence ('Get list of column in a table') that is front-loaded and avoids unnecessary words. However, it contains a grammatical error ('column' should be 'columns'), which slightly detracts from clarity but does not significantly impact conciseness.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the complexity of database interactions, lack of annotations, no output schema, and 0% schema description coverage, the description is incomplete. It does not address critical aspects like return values, error handling, or behavioral constraints, leaving significant gaps for an AI agent to understand and use the tool effectively.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
The schema description coverage is 0%, meaning parameters are undocumented in the schema. The description adds no meaning beyond the schema, as it does not explain what 'db_type', 'connection_string', or 'table_name' represent, their formats, or usage. With 3 parameters and no compensation in the description, this fails to provide necessary semantic context.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description states the tool's purpose ('Get list of column in a table'), which is clear but vague. It specifies the verb ('Get') and resource ('column in a table'), but lacks specificity about scope or differentiation from sibling tools like 'get_tables' (which likely lists tables rather than columns). However, it avoids tautology by not merely restating the name/title.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
The description provides no guidance on when to use this tool versus alternatives. It does not mention sibling tools such as 'execute_query' or 'get_tables', nor does it specify prerequisites, exclusions, or contextual cues for selection. This leaves the agent without explicit direction on tool choice.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
get_tablesGet TablesC
Get list of table in database
| Name | Required | Description | Default |
|---|---|---|---|
| db_type | Yes | ||
| connection_string | Yes |
TDQS
Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?
With no annotations provided, the description carries the full burden of behavioral disclosure. It states a read operation ('Get list'), which implies it's non-destructive, but doesn't cover permissions, rate limits, output format, or error handling. This is a significant gap for a tool that interacts with databases, making it inadequate for safe and effective use.
Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.
Is the description appropriately sized, front-loaded, and free of redundancy?
The description is a single, efficient sentence that gets straight to the point without unnecessary words. However, the grammatical error ('table' vs. 'tables') slightly detracts from clarity, but it remains appropriately sized and front-loaded.
Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.
Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?
Given the complexity of database interactions, no annotations, no output schema, and 0% schema description coverage, the description is incomplete. It lacks details on behavior, parameters, output, and usage context, making it insufficient for an AI agent to reliably invoke this tool without additional assumptions or errors.
Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.
Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?
Schema description coverage is 0%, so the schema provides no parameter descriptions. The tool description adds no information about the parameters (db_type, connection_string), their meanings, or how they affect the operation. This leaves both parameters entirely undocumented, failing to compensate for the schema's lack of coverage.
Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.
Does the description clearly state what the tool does and how it differs from similar tools?
The description 'Get list of table in database' clearly states the action (get/list) and resource (tables), but it's grammatically incorrect ('table' should be 'tables') and doesn't distinguish from sibling tools like 'get_columns' or 'execute_query'. It provides a basic purpose but lacks specificity about scope or differentiation.
Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.
Does the description explain when to use this tool, when not to, or what alternatives exist?
No guidance is provided on when to use this tool versus alternatives like 'get_columns' or 'execute_query'. The description implies it's for listing tables, but there's no explicit context, exclusions, or prerequisites mentioned, leaving the agent to infer usage based on tool names alone.
Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections. Dates show when Glama detected each change.
3 tool updates
- First observed
execute_query - First observed
get_columns - First observed
get_tables
TDQS
Each tool has a clearly distinct purpose: execute_query runs queries, get_columns lists columns in a table, and get_tables lists tables in a database. There is no overlap or ambiguity between these operations.
All tool names follow a consistent verb_noun pattern (execute_query, get_columns, get_tables) with clear, descriptive verbs and nouns. No deviations or mixed conventions are present.
With only 3 tools, the server feels thin for an SQL domain, lacking operations like insert, update, delete, or schema modifications. While the tools are well-defined, the count is borderline low for comprehensive database interaction.
The tool set is severely incomplete for an SQL server, missing essential CRUD operations (e.g., insert, update, delete) and schema management tools. This will cause significant agent failures when trying to perform common database tasks beyond basic queries and metadata retrieval.
Maintenance
Resources
Unclaimed servers have limited discoverability.
Looking for Admin?
If you are the server author, to access and configure the admin panel.
Related MCP Connectors
A Model Context Protocol (MCP) server for Selise Blocks Cloud integration
A comprehensive Model Context Protocol (MCP) server that enables AI assistants to interact with yo…
The Mercado Pago MCP Server implements the Model Context Protocol to provide AI agents and LLMs with access to Mercado Pago's APIs and tools within compatible development environments. It acts as an intermediary that translates Mercado Pago resources into executable functions (tools) that AI applications can invoke to perform actions and automate flows. The server simplifies integration, enables using documentation to implement or improve code, and optimizes operations through natural language interactions without manual implementations.
Related MCP Servers
- FlicenseNot gradedqualityDmaintenanceA Model Context Protocol server that provides tools for connecting to and interacting with various database systems (SQLite, PostgreSQL, MySQL/MariaDB, SQL Server) through a unified interface.3-
- AlicenseBqualityAmaintenanceA Model Context Protocol server that enables SQL operations (SELECT, INSERT, UPDATE, DELETE) and table management through a standardized interface with SQLite databases.71401ISC
- AlicenseBqualityDmaintenanceA Model Context Protocol server that enables executing SQL queries and managing connections with Microsoft SQL Server databases.13,3386MIT
- AlicenseBqualityDmaintenanceA Model Context Protocol (MCP) server for Microsoft SQL Server that provides tools for database operations, data analysis, and visualization generation.8MIT
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/adetxt/sql-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server