mbentham/SqlAugur

Added

• NuGet global tool packaging (dotnet tool install -g SqlAugur)
• Docker and Podman container support with Dockerfile
• Configuration search path (app directory, user config directory, current working directory, env vars, CLI args)
• Server version reported from assembly metadata
• Schema exploration toolset: list_programmable_objects, get_object_definition, get_extended_properties, get_object_dependencies
• Mermaid ER diagram generation (get_mermaid_diagram)
• Toolset reorganization: Schema Exploration and Diagrams as always-available toolsets in dynamic mode
• Documentation rework: restructured README, added CONTRIBUTING.md and CHANGELOG.md

Changed

• Breaking: Renamed project from SqlServerMcp to SqlAugur (config section "SqlAugur", CLI command sqlaugur)
• Removed create/modify dates from list_programmable_objects output

Fixed

• Sanitized markdown table cells in TableDescribeService to prevent output corruption

What's Changed

Strips JSON overhead from all tool responses to reduce token usage. LLMs already know the server/database they asked about, can count array elements, and can infer column types from values — so redundant metadata was removed across the board.

Breaking Changes

• list_servers — Returns plain comma-separated text (production, staging) instead of a JSON array
• list_databases — Returns plain comma-separated text (master, AdventureWorks) instead of a JSON envelope with server, databaseCount, and per-database metadata
• read_data — Response now contains only truncated and rows. Removed server, rowCount, and columns (type metadata)
• get_query_plan — Now writes XML to a .sqlplan file and returns a confirmation message instead of returning inline JSON with the plan XML. New required outputPath parameter
• All stored procedure tools (sp_Blitz, sp_BlitzFirst, sp_BlitzCache, sp_BlitzIndex, sp_BlitzWho, sp_BlitzLock, sp_WhoIsActive, sp_PressureDetector, sp_QuickieStore, sp_HealthParser, sp_LogHunter, sp_HumanEventsBlockViewer, sp_IndexCleanup, sp_QueryReproBuilder) — Response is now a JSON array of {truncated, rows} objects (one per result set). Removed server, procedureName, columns, and rowCount

Internal Improvements

• Extracted ToolHelper.SaveToFileAsync shared helper for file-write validation (extension check, directory creation, line count confirmation) — used by both get_plantuml_diagram and get_query_plan
• File extension validation now uses Path.GetExtension instead of EndsWith for precision
• Tightened tool descriptions for diagram and schema overview tools
• Updated README with release install and clone-from-source setup options

Full Changelog: https://github.com/mbentham/MCP-Server-SQLServer/compare/v1.1.0...v1.2.0

What's Changed

Adds table-level filtering and multi-schema support to get_plantuml_diagram and get_schema_overview tools.

New Features

• Table filtering — New includeTables and excludeTables comma-separated parameters on both get_plantuml_diagram and get_schema_overview. Filter diagrams and overviews to specific tables (e.g. includeTables: "Users,Orders") or exclude tables (e.g. excludeTables: "AuditLog,TempData"). Include overrides exclude.
• Multi-schema include — includeSchema (single value) replaced with includeSchemas (comma-separated list, e.g. includeSchemas: "dbo,sales"). Now consistent with excludeSchemas.
• Schema and table filters compose independently — both are applied as separate WHERE clauses joined by AND, so you can combine includeSchemas: "dbo" with includeTables: "Users,Products" to narrow results precisely.

Breaking Changes

• includeSchema parameter renamed to includeSchemas on both get_plantuml_diagram and get_schema_overview tools. Update any existing tool calls that use this parameter.

Internal Improvements

• ParseExcludeSchemas renamed to generic ParseCommaSeparatedList — used for all four filter parameters
• Extracted AppendFilter helper in SchemaQueryHelper to deduplicate parameterized IN/NOT IN clause generation
• All filter values use parameterized SQL (SqlParameter) — no string concatenation

Test Coverage

• 9 new unit tests for table filters, multi-schema includes, and filter composition
• 8 new integration tests (4 per service) verifying table include/exclude, multi-schema include, and combined schema+table filtering against a real SQL Server instance

Full Changelog: https://github.com/mbentham/MCP-Server-SQLServer/compare/v1.0.1...v1.1.0