sql-mcp
A read-only MCP server for SQL Server and PostgreSQL that enables exploring and querying databases (schemas, tables, views, procedures, indexes, foreign keys) and running arbitrary SELECT queries.
Caution. Specific findings reduced this grade. They are listed on the page. Grades reflect the full trust pyramid: code, verification depth, and reputation. New projects cap at C until adoption is earned.
How we verified
Verified is a snapshot. Live keeps it current, and builds your track record.
⚡ Connect GitHub → continuous verification on every pushwhy connect →Who stands behind it
teghoz
Source: Glama
Claim it to get a verified publisher badge, a free copy of our full audit findings, and direct contact for any high-priority issues we find. Or connect your repo for our deepest verification, Live Monitored: read-only, revoke anytime. What we access →
Install from
The grade above is for the source repository. Registries can serve a different version, so we mark the ones we were not able to read.
These names and descriptions are the publisher's own, read from the source code. We print them as written. Our assessment is the findings above, not this list.
list_linked_serversget_server_propertiesGet SQL Server instance properties: version, edition, collation, clustering, and HA configuration
list_agent_jobsget_job_historyget_table_constraintsGet all constraints on a table: PRIMARY KEY, UNIQUE, CHECK, and DEFAULT
list_databasesList all online databases on the SQL Server instance
get_extended_propertiesGet all extended properties (e.g. MS_Description documentation) for a table, view, procedure, or function — includes both the object-level and all column-level properties
list_fulltext_catalogsList all full-text search catalogs in a database with item count, size, and populate status
list_fulltext_indexesList all full-text indexes in a database, showing the catalog, indexed columns, and change-tracking state
list_functionsList all user-defined functions in a database (scalar, inline table-valued, and multi-statement table-valued), optionally filtered by schema
get_function_definitionGet the full source definition of a user-defined function
list_partition_functionsList all partition functions in the current database, including range type, partition count, and boundary values
list_partition_schemesList all partition schemes in the current database, showing which partition function each uses and the mapped filegroups
execute_querylist_schemasList all schemas in a database
list_database_usersList all users in a database with their type, default schema, and mapped login
list_database_rolesList all database roles and their members. Uses LEFT JOIN so roles with no members are included.
get_object_permissionsGet all explicit permissions granted on a specific database object
list_sequencesList all sequences in a database, optionally filtered by schema. Shows data type, range, increment, cycling, and current value.
list_service_queuesList all Service Broker queues in a database, optionally filtered by schema
list_broker_servicesList all Service Broker services in a database and the queue each binds to
list_stored_proceduresList all stored procedures in a database, optionally filtered by schema
get_stored_procedure_definitionGet the full source definition of a stored procedure
list_synonymsList all synonyms in a database, optionally filtered by schema
get_synonym_definitionGet the base object a synonym points to
get_table_statsGet row count and disk space usage (total, used, unused) for a table
list_tablesList all tables in a database, optionally filtered by schema
describe_tableGet column definitions for a table
get_table_indexesGet all indexes defined on a table
get_foreign_keysGet all foreign key relationships for a table
list_temporal_tablesList all system-versioned temporal tables in a database, showing the linked history table for each
list_triggersList all DML triggers in a database, optionally filtered by schema and/or parent table
get_trigger_definitionGet the full source definition of a DML trigger
list_user_typesList all user-defined types (scalar alias types and table types) in a database, optionally filtered by schema
get_table_type_columnsGet the column definitions for a user-defined table type
list_viewsList all views in a database, optionally filtered by schema
describe_viewGet column definitions and the SQL definition for a view
Disclosed vulnerabilities in this server's declared npm dependencies (via OSV). Whether each is reachable depends on the installed versions.
Model Context Protocol (MCP) TypeScript SDK does not enable DNS rebinding protection by default
AUDIT_DATABASESet AUDIT_CONNECTION_STRING (or to reuse the main connection params with a different database) to also insert records into a SQL table.AUDIT_LOG_PATHA daily-rotating JSON log file is written to ${}/audit-YYYY-MM-DD.log (UTC date). Each line is a JSON object:DB_PROVIDERSet to choose the database engine. Defaults to mssql.PG_AZURE_AD_AUTHtrue and the server mints a token on demand per connectionPG_DATABASEpostgres # default database for queriesPG_HOSTmyserver.postgres.database.azure.comPG_PASSWORDyour_passwordPG_PORT5432 # default: 5432PG_SSLfalse # true for SSL connectionsPG_STATEMENT_TIMEOUT30000 # query timeout in ms (default: 30000)PG_USERmy_entra_principal # the AAD user/group mapped as a PostgreSQL roleSQL_ALLOWED_SCHEMASComma-separated list of schemas the MCP may access. When unset, all schemas are accessible.SQL_BLOCKED_TABLESComma-separated schema.table pairs that are hidden from listing tools and blocked when accessed directly.SQL_DATABASEmaster # default database for queriesSQL_ENCRYPTfalse # true for Azure SQLSQL_MASKED_COLUMNSComma-separated schema.table.column values whose content is replaced with [MASKED] in every response.SQL_MAX_ROWSHard cap on rows returned by any tool (default: 5000).SQL_PASSWORDyour_passwordSQL_PORT1433 # default: 1433SQL_REQUEST_TIMEOUT30000 # query timeout in ms (default: 30000)SQL_SERVER"": "myserver",SQL_TRUST_SERVER_CERTIFICATEtrue # true for self-signed certs in devSQL_USER"": "myuser",AUDIT_CONNECTION_STRINGPG_CONNECTION_STRINGPORTSQL_CONNECTION_STRINGTool annotations
No tools have read-only/destructive annotations
Add readOnlyHint or destructiveHint annotations to every tool so hosts can warn users before invoking.
All four hints declared on every tool
53/53 tools missing one or more hints — list_linked_servers (missing: readOnlyHint, destructiveHint, idempotentHint, openWorldHint); get_server_properties (missing: readOnlyHint, destructiveHint, idempotentHint, openWorldHint); get_server_properties (missing: readOnlyHint, destructiveHint, idempotentHint, openWorldHint), +50 more. OpenAI's directory rejects tools where any of the four hints are missing or non-boolean.
For every tool, set all four hints (readOnlyHint, destructiveHint, idempotentHint, openWorldHint) to explicit true/false values that match the handler’s actual behaviour.
License file
No license file
Add a LICENSE file (MIT, Apache-2.0, etc.).
Tests exist
No test files found
Add tests that exercise each declared tool.
Production dependencies are patched
0 critical, 1 high severity in production deps — @modelcontextprotocol/sdk@1.0.0 (high)
Run npm audit fix, or upgrade the affected packages to a non-vulnerable version.
Claim the listing to review these findings one by one and send us a correction where you disagree, straight to the team. Claiming also means we tell you when the grade moves, and reach you first if we find anything urgent.
[](https://m8ven.ai/mcp/teghoz/sql-mcp)?variant=verified from the URL.Vetting this one by hand? Tool Check is an MCP that scores other MCPs. Add it once and ask Claude, ChatGPT, or any MCP client to grade a server, surface CVEs, check the publisher, and suggest safer alternatives — before you install.
https://m8ven.ai/api/mcp/tool-check