mcpqlSAFE
MCPQL - MCP Server for SQL Server database operations and analysis
Overview
From the repository's own README, as read at the audited commit. Badges and raw HTML are left out.
[](https://opensource.org/licenses/MIT) [](https://nodejs.org/) [](https://www.typescriptlang.org/) [](https://www.npmjs.com/package/mcpql) [](https://www.npmjs.com/package/mcpql) [](https://github.com/hendrickcastro/MCPQL/stargazers) [](https://github.com/hendrickcastro/MCPQL/issues) [](https://github.com/hendrickcastro/MCPQL/network) [](https://github.com/hendrickcastro/MCPQL/actions) [](https://codecov.io/gh/hendrickcastro/MCPQL) [](https://www.microsoft.com/sql-server) [](https://azure.microsoft.com/services/sql-database/) [](https://github.com/modelcontextprotocol/sdk) [](https://claude.ai/desktop) [](https://cursor.sh/) [](https://trae.ai/) [](https://hub.docker.com/r/hendrickcastro/mcpql) [](https://github
cfdd15692673OBSERVED · 2026-10-12Connect
Built from this server's own package name, version and transport as found in its source — not copied from anyone's documentation, so it cannot drift against a page we do not control. Replace the environment placeholders with a token scoped to the least it needs.
claude mcp add mcpql --env DB_AUTHENTICATION_TYPE=${DB_AUTHENTICATION_TYPE} --env DB_AZURE_CLIENT_SECRET=${DB_AZURE_CLIENT_SECRET} --env DB_PASSWORD=${DB_PASSWORD} -- npx -y [email protected]{
"mcpServers": {
"mcpql": {
"command": "npx",
"args": [
"-y",
"[email protected]"
],
"env": {
"DB_AUTHENTICATION_TYPE": "${DB_AUTHENTICATION_TYPE}",
"DB_AZURE_CLIENT_SECRET": "${DB_AZURE_CLIENT_SECRET}",
"DB_PASSWORD": "${DB_PASSWORD}"
}
}
}
}Exposed tools (11)
9 read · 2 write · 0 destructive.
| Tool | Risk | Description |
|---|---|---|
mcp_execute_procedure | write | Execute a SQL Server stored procedure with parameters and return results |
mcp_execute_query | write | Execute a raw SQL query and return the results |
mcp_get_column_stats | read | Get comprehensive statistics for a specific column in a table |
mcp_get_dependencies | read | Get dependencies for a database object (tables, views, stored procedures, etc.) |
mcp_get_sample_values | read | Get sample values from a specific column in a table |
mcp_get_security_status | read | Get current security configuration and status for database operations |
mcp_preview_data | read | Get a preview of data from a SQL Server table with optional filters |
mcp_quick_data_analysis | read | Quick statistical analysis of a table including row count, column distributions, and top values |
mcp_search_comprehensive | read | Search across database objects by name and definition with configurable criteria |
mcp_sp_structure | read | Analyze SQL Server stored procedure structure including parameters, dependencies, and source code |
mcp_table_analysis | read | Comprehensive SQL Server table analysis including structure, columns, keys, indexes, and constraints |
Trust audit
SAFEgrade B · trust 89/100 Nothing in the source contradicts what it says it does. Grade A is reserved for packages that have also passed the behavioural sandbox.
| Layer | What it checks | Result |
|---|---|---|
| L0 | Provenance & inventory | PASS |
| L1 | Static analysis of the code | PASS |
| L2 | Instruction surface (what it tells the agent) | PASS |
| L3 | Class-specific surface | PASS |
| L4 | Behavioural (sandbox) | SKIPPED |
What the source does
- Filesystem
- none-observed
- Network
- none-observed
- Shell
- declared (2 observation(s))
- Dependencies
- not all pinned
- Secrets in source
- none-found
Findings (1)
@azure/msal-common, @modelcontextprotocol/sdk, dotenv, mssql, @types/jest, @types/mssql, @types/node, chalk
Gates applied: no_behavioural_pass.
cfdd15692673full audit observations/trust-audit/mcp-server/hendrickcastro__mcpql.json · Report an issue / request a re-scanAudit history
Every audit this server has had. A grade with a past is a grade somebody is still checking.
| Date | Source | Verdict | Grade | Score | Change |
|---|---|---|---|---|---|
| 2026-10-12 | cfdd15692673 | SAFE | B | 89 | first audit |
Questions
What is the mcpql MCP server?
MCPQL - MCP Server for SQL Server database operations and analysis
What tools does mcpql expose?
11 in total: 9 read-only, 2 that write, and 0 that can delete or overwrite. Every one is listed on this page with its risk.
Is mcpql safe to connect to an agent?
The audit found nothing in the source that contradicts what it says it does, and graded it B (89/100). Grade A is held back for packages that have also passed a sandboxed behavioural run, which is why a clean server reads B.
What credentials does mcpql need?
It reads DB_AUTHENTICATION_TYPE, DB_AZURE_CLIENT_SECRET and DB_PASSWORD from the environment. Give it a token scoped to the least it needs — an agent that can be talked into calling a tool can be talked into calling it with your credentials.
How does mcpql run?
It speaks stdio, so it runs as a local process your client starts. It is published on npm as mcpql at 1.0.1.
How current is this page?
The grade is for one exact copy of the source (cfdd15692673), read on 2026-10-12. The repository is watched and re-audited when it changes.