{"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":[]}},"summary":{"outcome":"started","needs":[],"contacts":[],"flags":[{"kind":"orders","tool":"mssql_read_table_rows","quote":"ames are validated as safe identifiers. WHERE clause values MUST be passed via 'parameters' using @paramName placeholders. Pagination: limit (1-200, default 20) and"}],"tools":14,"wrote":0,"callsTried":4,"callsAnswered":1,"callContacts":[]},"history":[{"package":"mssql-mcp","version":"3.0.0","ranAt":"2026-11-16T11:37:16.654Z","outcome":"started","tools":14,"contacts":0,"flags":1,"serious":0,"toolsHash":"ff5bc82deda7a7a6890fd475927252cda152efaf08ba11c0b38dbca6e30089ba"}],"page":"https://bragproof.smaverk.com/r/mssql-mcp"}