{"report":"{\"v\":1,\"package\":\"mssql-mcp-server\",\"version\":\"1.3.0\",\"ranAt\":\"2026-11-16T11:31:53.345Z\",\"install\":{\"ok\":true,\"integrity\":\"sha512-2/06+9PqmOPNugSBrZlwjXdSrI5gl2QSPrudLLTP8MsM0m7OqI8fdrEtmayR/9zave1lh+kJDCqM9s42XP/O5g==\",\"deps\":162,\"scripts\":[],\"bins\":[\"mssql-mcp-server\"],\"license\":\"MIT\",\"engines\":\"node >=20.0.0\",\"repository\":\"git+https://github.com/vicagbasi/mssql-mcp.git\",\"bin\":\"mssql-mcp-server\"},\"start\":{\"ok\":true,\"ms\":396,\"serverName\":\"mssql-mcp-server\",\"serverVersion\":\"1.2.0\",\"protocol\":\"2025-06-18\",\"stderr\":\"Registering core database tools...\\nRegistering schema discovery tools...\\nRegistering index and performance tools...\\nRegistering constraint analysis tools...\\nRegistering data pattern analysis tools...\\nRegistering enhanced stored procedure tools...\\nAll tools registered successfully. Starting server...\\nMSSQL MCP Server started successfully!\\n\"},\"tools\":[{\"name\":\"list_connections\",\"description\":\"List all available named database connections configured in the server\",\"params\":[]},{\"name\":\"test_connection\",\"description\":\"Test the database connection and return basic server information\",\"params\":[\"connectionName\"]},{\"name\":\"list_databases\",\"description\":\"List all databases available on the SQL Server instance\",\"params\":[\"connectionName\"]},{\"name\":\"list_tables\",\"description\":\"List all tables in the connected database\",\"params\":[\"connectionName\",\"schema\"]},{\"name\":\"describe_table\",\"description\":\"Get detailed schema information for a specific table including columns, data types, and constraints\",\"params\":[\"connectionName\",\"tableName\",\"schema\"]},{\"name\":\"sample_data\",\"description\":\"Retrieve sample data from a table (top 10 rows by default)\",\"params\":[\"connectionName\",\"tableName\",\"schema\",\"limit\"]},{\"name\":\"execute_query\",\"description\":\"Execute a custom SQL SELECT query with automatic limit (top 20 rows). Disabled unless MSSQL_ENABLE_EXECUTE_QUERY=true.\",\"params\":[\"connectionName\",\"query\"]},{\"name\":\"get_relationships\",\"description\":\"Get foreign key relationships between tables in the database\",\"params\":[\"connectionName\",\"schema\"]},{\"name\":\"list_stored_procedures\",\"description\":\"List all stored procedures, functions, and their basic information\",\"params\":[\"connectionName\",\"schema\",\"includeSystemObjects\"]},{\"name\":\"describe_stored_procedure\",\"description\":\"Get detailed information about a specific stored procedure including parameters and definition\",\"params\":[\"connectionName\",\"procedureName\",\"schema\",\"includeDefinition\"]},{\"name\":\"list_views\",\"description\":\"List all views in the database with their basic information\",\"params\":[\"connectionName\",\"schema\",\"includeSystemViews\"]},{\"name\":\"describe_view\",\"description\":\"Get detailed information about a specific view including its definition and dependencies\",\"params\":[\"connectionName\",\"viewName\",\"schema\",\"includeDefinition\"]},{\"name\":\"list_triggers\",\"description\":\"List all triggers in the database with their associated tables\",\"params\":[\"connectionName\",\"schema\",\"tableName\"]},{\"name\":\"describe_trigger\",\"description\":\"Get detailed information about a specific trigger including its definition and events\",\"params\":[\"connectionName\",\"triggerName\",\"includeDefinition\"]},{\"name\":\"list_functions\",\"description\":\"List all user-defined functions (scalar, table-valued, etc.)\",\"params\":[\"connectionName\",\"schema\",\"functionType\"]},{\"name\":\"list_indexes\",\"description\":\"List all indexes on tables with usage statistics and detailed information\",\"params\":[\"connectionName\",\"schema\",\"tableName\",\"includeUsageStats\"]},{\"name\":\"analyze_table_stats\",\"description\":\"Get table row counts, size information, and last update statistics\",\"params\":[\"connectionName\",\"schema\",\"tableName\"]},{\"name\":\"find_missing_indexes\",\"description\":\"Identify potentially missing indexes based on query execution patterns\",\"params\":[\"connectionName\",\"schema\",\"minImpact\"]},{\"name\":\"analyze_index_usage\",\"description\":\"Show detailed index usage statistics to identify unused or underutilized indexes\",\"params\":[\"connectionName\",\"schema\",\"tableName\",\"showUnusedOnly\"]},{\"name\":\"analyze_database_size\",\"description\":\"Get comprehensive database size information including data and log file sizes\",\"params\":[\"connectionName\"]},{\"name\":\"list_constraints\",\"description\":\"List all constraints (check, unique, foreign key, etc.) across tables in the database\",\"params\":[\"connectionName\",\"schema\",\"constraintType\"]},{\"name\":\"analyze_check_constraints\",\"description\":\"Extract and analyze business rules from check constraints\",\"params\":[\"connectionName\",\"schema\",\"tableName\"]},{\"name\":\"list_user_defined_types\",\"description\":\"List all user-defined data types and their definitions\",\"params\":[\"connectionName\",\"schema\"]},{\"name\":\"find_computed_columns\",\"description\":\"List computed columns and their formulas to understand derived business logic\",\"params\":[\"connectionName\",\"schema\",\"tableName\"]},{\"name\":\"list_default_constraints\",\"description\":\"List all default value constraints and their definitions\",\"params\":[\"connectionName\",\"schema\",\"tableName\"]},{\"name\":\"analyze_data_distribution\",\"description\":\"Get data distribution patterns for columns to understand data quality and patterns\",\"params\":[\"connectionName\",\"tableName\",\"schema\",\"columnName\",\"sampleSize\"]},{\"name\":\"find_lookup_tables\",\"description\":\"Identify reference/lookup tables automatically based on table patterns\",\"params\":[\"connectionName\",\"schema\",\"maxRows\"]},{\"name\":\"analyze_null_patterns\",\"description\":\"Find columns with high null percentages and analyze null patterns\",\"params\":[\"connectionName\",\"schema\",\"minNullPercentage\"]},{\"name\":\"detect_audit_columns\",\"description\":\"Identify common audit trail patterns (created/modified dates, user tracking)\",\"params\":[\"connectionName\",\"schema\"]},{\"name\":\"get_stored_procedure_definition\",\"description\":\"Get the complete SQL query/definition of a stored procedure - this is the actual source code\",\"params\":[\"connectionName\",\"procedureName\",\"schema\",\"formatOutput\"]},{\"name\":\"get_multiple_stored_procedure_definitions\",\"description\":\"Get complete SQL definitions for multiple stored procedures at once\",\"params\":[\"connectionName\",\"procedureNames\",\"schema\",\"includeMetadata\"]},{\"name\":\"get_all_stored_procedure_definitions\",\"description\":\"Get complete SQL definitions for all stored procedures in a schema\",\"params\":[\"connectionName\",\"schema\",\"includeSystemProcedures\",\"maxResults\"]},{\"name\":\"search_stored_procedures_by_content\",\"description\":\"Search for stored procedures containing specific text or patterns in their SQL definition\",\"params\":[\"connectionName\",\"searchText\",\"schema\",\"caseSensitive\",\"includeDefinitions\"]}],\"toolsHash\":\"5aa424a4ae8a930ffa62be527a0f0d0fbf84c7ff2101b32c9f5a1d5cecfb3562\",\"wrote\":[],\"callsAt\":\"2026-11-16T11:32:03.956Z\",\"calls\":[{\"tool\":\"list_connections\",\"ok\":true,\"ms\":3,\"bytes\":94},{\"tool\":\"list_databases\",\"ok\":false,\"ms\":2,\"bytes\":0,\"error\":\"tool reported an error: Error listing databases: No connection string provided and no default connection string configured\"},{\"tool\":\"list_tables\",\"ok\":false,\"ms\":0,\"bytes\":0,\"error\":\"tool reported an error: Error listing tables: No connection string provided and no default connection string configured\"},{\"tool\":\"get_relationships\",\"ok\":false,\"ms\":1,\"bytes\":0,\"error\":\"tool reported an error: Error retrieving relationships: No connection string provided and no default connection string configured\"},{\"tool\":\"list_views\",\"ok\":false,\"ms\":1,\"bytes\":0,\"error\":\"tool reported an error: Error listing views: No connection string provided and no default connection string configured\"}],\"host\":{\"commit\":\"eaaffffaf52255d1b77dc4aacffdfaf353f0c12c\",\"run\":\"https://github.com/itsHaddad/bragproof/actions/runs/43857070216\"},\"network\":{\"names\":[\"registry.npmjs.org\"],\"conns\":[],\"callNames\":[],\"callConns\":[]}}","token":"eyJhbGciOiJSUzI1NiIsImtpZCI6IjM4ODI2YjE3LTZhMzAtNWY5Yi1iMTY5LThiZWI4MjAyZjcyMyIsInR5cCI6IkpXVCIsIng1dCI6InlrTmFZNHFNX3RhNGsyVGdaT0NFWUxrY1lsQSJ9.eyJhY3RvciI6Iml0c0hhZGRhZCIsImFjdG9yX2lkIjoiMTE0NzMyNjEiLCJhdWQiOiJicmFncHJvb2YtcmVwb3J0OmIzYzhkODEyNjNiNTA1YTkwN2Q0OWE3YmM2NGVlMzQyYjlkMjhlMWUxYTNiMWY3MjlmNjU3MzhlMmY0MjU3ZjAiLCJiYXNlX3JlZiI6IiIsImNoZWNrX3J1bl9pZCI6IjEzMzI2Mzk5NTUxMyIsImV2ZW50X25hbWUiOiJzY2hlZHVsZSIsImV4cCI6MTc5NDgyOTAzMCwiaGVhZF9yZWYiOiIiLCJpYXQiOjE3OTQ4Mjg3MzAsImlzcyI6Imh0dHBzOi8vdG9rZW4uYWN0aW9ucy5naXRodWJ1c2VyY29udGVudC5jb20iLCJqb2Jfd29ya2Zsb3dfcmVmIjoiaXRzSGFkZGFkL2JyYWdwcm9vZi8uZ2l0aHViL3dvcmtmbG93cy9yZXBvcnQueW1sQHJlZnMvaGVhZHMvbWFpbiIsImpvYl93b3JrZmxvd19zaGEiOiJlYWFmZmZmYWY1MjI1NWQxYjc3ZGM0YWFjZmZkZmFmMzUzZjBjMTJjIiwianRpIjoiZDBmOGQ1NGItY2Q4NC00ZmQ5LWIwZTAtMDk3OTQzOGUxZDAzIiwibmJmIjoxNzk0ODI4NDMwLCJyZWYiOiJyZWZzL2hlYWRzL21haW4iLCJyZWZfcHJvdGVjdGVkIjoiZmFsc2UiLCJyZWZfdHlwZSI6ImJyYW5jaCIsInJlcG9zaXRvcnkiOiJpdHNIYWRkYWQvYnJhZ3Byb29mIiwicmVwb3NpdG9yeV9pZCI6IjE0NTQ2MjExODMiLCJyZXBvc2l0b3J5X293bmVyIjoiaXRzSGFkZGFkIiwicmVwb3NpdG9yeV9vd25lcl9pZCI6IjExNDczMjYxIiwicmVwb3NpdG9yeV92aXNpYmlsaXR5IjoicHVibGljIiwicnVuX2F0dGVtcHQiOiIxIiwicnVuX2lkIjoiNDM4NTcwNzAyMTYiLCJydW5fbnVtYmVyIjoiMjQiLCJydW5uZXJfZW52aXJvbm1lbnQiOiJnaXRodWItaG9zdGVkIiwic2hhIjoiZWFhZmZmZmFmNTIyNTVkMWI3N2RjNGFhY2ZmZGZhZjM1M2YwYzEyYyIsInN1YiI6InJlcG86aXRzSGFkZGFkQDExNDczMjYxL2JyYWdwcm9vZkAxNDU0NjIxMTgzOnJlZjpyZWZzL2hlYWRzL21haW4iLCJ3b3JrZmxvdyI6InJlcG9ydCIsIndvcmtmbG93X3JlZiI6Iml0c0hhZGRhZC9icmFncHJvb2YvLmdpdGh1Yi93b3JrZmxvd3MvcmVwb3J0LnltbEByZWZzL2hlYWRzL21haW4iLCJ3b3JrZmxvd19zaGEiOiJlYWFmZmZmYWY1MjI1NWQxYjc3ZGM0YWFjZmZkZmFmMzUzZjBjMTJjIn0.4PU50g0yd_nafDLQSeEkQbyLVoSSZjXak4IWblGFiwTzKx4ybw8JwN8QA8t9DZwuoKe0RblauP31BQH8Kkh2wlc__JFuv3cj64heF0xSM6X8nSRcHxHsjIPTEgQnkHum8_rmou0o-VbI4ezZSUG-vJQ3Q89VhGeuY9MEdCX0f-DwfZvNh5fFkCDs9s1KDWuUGlYMm39ay1Vuf6TLLNcKAYR5TehdjwgqxehkDLk2Rj97qAND9bDFybJ6_QK1A3myMrca2cnlWW3lu76KQbjNlunxZeIZk7AhUV0jX5fmOnq_xy-_gfYjhPMLq88VB6pdbb6QF8xVqGZ05HTJBsS15g"}