{"report":"{\"v\":1,\"package\":\"mssql-mcp\",\"version\":\"3.0.0\",\"ranAt\":\"2026-11-16T11:37:16.654Z\",\"install\":{\"ok\":true,\"integrity\":\"sha512-azf2othoh7sayIbluOtA85U8UTjE8Iznay9tfgnrXjcizw0KN1XAmFAVL41eocDUuqrYDZcwiSF9AvXcAnGn2w==\",\"deps\":82,\"scripts\":[],\"bins\":[\"mssql-mcp-server\"],\"license\":\"MIT\",\"engines\":\"node >=20.0.0\",\"repository\":\"git+https://github.com/BYMCS/mssql-mcp.git\",\"bin\":\"mssql-mcp-server\"},\"start\":{\"ok\":true,\"ms\":322,\"serverName\":\"mssql-mcp-server\",\"serverVersion\":\"3.0.0\",\"protocol\":\"2025-06-18\",\"stderr\":\"MSSQL MCP Server v3.0.0 starting (stdio mode)...\\nServer ready.\\nmssql_list_schema_objects failed: No active database connection. Use connect_database first.\\nmssql_list_databases failed: No active database connection. Use connect_database first.\\n\"},\"tools\":[{\"name\":\"mssql_connect_database\",\"description\":\"Connects to MS SQL Server using environment variables (DB_SERVER, DB_DATABASE, DB_USER, DB_PASSWORD, DB_PORT, DB_ENCRYPT, DB_TRUST_SERVER_CERTIFICATE). No credentials accepted as parameters — all connection settings come from the server environment only. Idempotent: calling again reconnects.\",\"params\":[]},{\"name\":\"mssql_disconnect_database\",\"description\":\"Closes the current database connection and releases the connection pool. Safe to call even if not connected. Idempotent.\",\"params\":[]},{\"name\":\"mssql_connection_status\",\"description\":\"Returns the current connection status, server address, database name, and connection pool metrics. Read-only. Safe to call at any time.\",\"params\":[]},{\"name\":\"mssql_run_sql_query\",\"description\":\"Executes an arbitrary SQL statement against the connected database. ⚠️ WARNING: This tool can read AND modify data (INSERT, UPDATE, DELETE, DDL). Always prefer parameterized inputs via the 'parameters' field — never embed user-supplied values directly in the query string. Example: query='SELECT * FROM dbo.Users WHERE Id = @id', parameters={id: 42}\",\"params\":[\"query\",\"parameters\",\"response_format\"]},{\"name\":\"mssql_execute_query\",\"description\":\"Deprecated alias for mssql_run_sql_query. Use mssql_run_sql_query instead. ⚠️ This tool can read AND modify data.\",\"params\":[\"query\",\"parameters\",\"response_format\"]},{\"name\":\"mssql_list_schema_objects\",\"description\":\"Lists tables, views, stored procedures, or functions in the connected database. Read-only. Supports filtering by schema name and pagination. Example: objectType='tables', schemaName='dbo', limit=20\",\"params\":[\"objectType\",\"schemaName\",\"limit\",\"offset\",\"response_format\"]},{\"name\":\"mssql_get_schema\",\"description\":\"Deprecated alias for mssql_list_schema_objects. Use mssql_list_schema_objects instead.\",\"params\":[\"objectType\",\"schemaName\",\"response_format\"]},{\"name\":\"mssql_describe_table_columns\",\"description\":\"Returns column definitions for a table: name, data type, length, nullability, default, and ordinal position. Read-only. Uses parameterized queries to prevent injection.\",\"params\":[\"tableName\",\"schemaName\",\"response_format\"]},{\"name\":\"mssql_describe_table\",\"description\":\"Deprecated alias for mssql_describe_table_columns.\",\"params\":[\"tableName\",\"schemaName\",\"response_format\"]},{\"name\":\"mssql_read_table_rows\",\"description\":\"Returns rows from a table with optional column projection, WHERE filtering, ORDER BY, and pagination. Read-only. Table and schema names are validated as safe identifiers. WHERE clause values MUST be passed via 'parameters' using @paramName placeholders. Pagination: limit (1-200, default 20) and offset. Example: tableName='Orders', schemaName='dbo', columns=['OrderId','Total'], limit=50\",\"params\":[\"tableName\",\"schemaName\",\"columns\",\"limit\",\"offset\",\"whereClause\",\"orderBy\",\"parameters\",\"response_format\"]},{\"name\":\"mssql_get_table_data\",\"description\":\"Deprecated alias for mssql_read_table_rows. Use mssql_read_table_rows instead. ⚠️ whereClause must use @paramName placeholders for all values.\",\"params\":[\"tableName\",\"schemaName\",\"limit\",\"offset\",\"whereClause\",\"orderBy\",\"parameters\",\"response_format\"]},{\"name\":\"mssql_execute_stored_procedure\",\"description\":\"Executes a stored procedure by name. ⚠️ May modify data — use only when an action is intended. Schema and procedure names are validated as safe identifiers. Pass all value parameters via 'parameters'.\",\"params\":[\"procedureName\",\"schemaName\",\"parameters\",\"response_format\"]},{\"name\":\"mssql_execute_procedure\",\"description\":\"Deprecated alias for mssql_execute_stored_procedure.\",\"params\":[\"procedureName\",\"schemaName\",\"parameters\",\"response_format\"]},{\"name\":\"mssql_list_databases\",\"description\":\"Lists all databases visible on the connected SQL Server instance with state and recovery information. Read-only. Supports pagination.\",\"params\":[\"limit\",\"offset\",\"response_format\"]}],\"toolsHash\":\"ff5bc82deda7a7a6890fd475927252cda152efaf08ba11c0b38dbca6e30089ba\",\"wrote\":[],\"callsAt\":\"2026-11-16T11:37:24.912Z\",\"calls\":[{\"tool\":\"mssql_connection_status\",\"ok\":true,\"ms\":4,\"bytes\":63},{\"tool\":\"mssql_list_schema_objects\",\"ok\":false,\"ms\":1,\"bytes\":0,\"error\":\"tool reported an error: ❌ Schema query failed: No active database connection. Use connect_database first.\"},{\"tool\":\"mssql_get_schema\",\"ok\":false,\"ms\":1,\"bytes\":0,\"error\":\"tool reported an error: ❌ Schema query failed: No active database connection. Use connect_database first.\"},{\"tool\":\"mssql_list_databases\",\"ok\":false,\"ms\":1,\"bytes\":0,\"error\":\"tool reported an error: ❌ List databases failed: No active database connection. Use connect_database first.\"}],\"host\":{\"commit\":\"eaaffffaf52255d1b77dc4aacffdfaf353f0c12c\",\"run\":\"https://github.com/itsHaddad/bragproof/actions/runs/43857070216\"},\"network\":{\"names\":[\"registry.npmjs.org\"],\"conns\":[],\"callNames\":[],\"callConns\":[]}}","token":"eyJhbGciOiJSUzI1NiIsImtpZCI6IjM4ODI2YjE3LTZhMzAtNWY5Yi1iMTY5LThiZWI4MjAyZjcyMyIsInR5cCI6IkpXVCIsIng1dCI6InlrTmFZNHFNX3RhNGsyVGdaT0NFWUxrY1lsQSJ9.eyJhY3RvciI6Iml0c0hhZGRhZCIsImFjdG9yX2lkIjoiMTE0NzMyNjEiLCJhdWQiOiJicmFncHJvb2YtcmVwb3J0OjBkNzAwODMzZjRhMDViZTRlNzU0ODg4OGRmOGNjMzE2ZmU0ODg1ZTg4YzMwODdjNzdmNDg2ODM1YjczMzM1ZDEiLCJiYXNlX3JlZiI6IiIsImNoZWNrX3J1bl9pZCI6IjEzMzI2Mzk5NTM2MyIsImV2ZW50X25hbWUiOiJzY2hlZHVsZSIsImV4cCI6MTc5NDgyOTM1MiwiaGVhZF9yZWYiOiIiLCJpYXQiOjE3OTQ4MjkwNTIsImlzcyI6Imh0dHBzOi8vdG9rZW4uYWN0aW9ucy5naXRodWJ1c2VyY29udGVudC5jb20iLCJqb2Jfd29ya2Zsb3dfcmVmIjoiaXRzSGFkZGFkL2JyYWdwcm9vZi8uZ2l0aHViL3dvcmtmbG93cy9yZXBvcnQueW1sQHJlZnMvaGVhZHMvbWFpbiIsImpvYl93b3JrZmxvd19zaGEiOiJlYWFmZmZmYWY1MjI1NWQxYjc3ZGM0YWFjZmZkZmFmMzUzZjBjMTJjIiwianRpIjoiOTM5ZjM5NmMtOTQyMS00ZjA0LWI2MWUtNTc0YzUxNTU1YzFjIiwibmJmIjoxNzk0ODI4NzUyLCJyZWYiOiJyZWZzL2hlYWRzL21haW4iLCJyZWZfcHJvdGVjdGVkIjoiZmFsc2UiLCJyZWZfdHlwZSI6ImJyYW5jaCIsInJlcG9zaXRvcnkiOiJpdHNIYWRkYWQvYnJhZ3Byb29mIiwicmVwb3NpdG9yeV9pZCI6IjE0NTQ2MjExODMiLCJyZXBvc2l0b3J5X293bmVyIjoiaXRzSGFkZGFkIiwicmVwb3NpdG9yeV9vd25lcl9pZCI6IjExNDczMjYxIiwicmVwb3NpdG9yeV92aXNpYmlsaXR5IjoicHVibGljIiwicnVuX2F0dGVtcHQiOiIxIiwicnVuX2lkIjoiNDM4NTcwNzAyMTYiLCJydW5fbnVtYmVyIjoiMjQiLCJydW5uZXJfZW52aXJvbm1lbnQiOiJnaXRodWItaG9zdGVkIiwic2hhIjoiZWFhZmZmZmFmNTIyNTVkMWI3N2RjNGFhY2ZmZGZhZjM1M2YwYzEyYyIsInN1YiI6InJlcG86aXRzSGFkZGFkQDExNDczMjYxL2JyYWdwcm9vZkAxNDU0NjIxMTgzOnJlZjpyZWZzL2hlYWRzL21haW4iLCJ3b3JrZmxvdyI6InJlcG9ydCIsIndvcmtmbG93X3JlZiI6Iml0c0hhZGRhZC9icmFncHJvb2YvLmdpdGh1Yi93b3JrZmxvd3MvcmVwb3J0LnltbEByZWZzL2hlYWRzL21haW4iLCJ3b3JrZmxvd19zaGEiOiJlYWFmZmZmYWY1MjI1NWQxYjc3ZGM0YWFjZmZkZmFmMzUzZjBjMTJjIn0.DrYrFjrslmF8Pm90qpax8W3TDBewX3bydt4ym7jRlz1VrVEkvk4hStdtRlI5MMZO6_mW-0A9dNaKFxJM7DnsSjoLIwQ4dIZIy6d3wJZfZSSsjrULjfJc2sYLvVZpQubG_OzQFNGM2QdMkikW-BvS-DcrEwXCI9mjt2lCpwRFZH0jOoz4KeUDlUh7roYfFJ-ynBi3w_b1vyK36k7lrM1csVxNrtnZ4_CAftm0VCXjzLTNScAIkV-HOj16sn-YLr9f3lbIvTdFQgfmXGMHT8xpdMGi1AFDX7zkjYDC1Wjbz-PO1mWFY7jqaYtRU1D8bmB8CfBgmqI2cbcMCFMlp47f7g"}