What problem does it solve? Querying SQL Server from scripts or an AI assistant usually means hand-writing connection strings, risking accidental writes, and leaking credentials into files. This Skill provides a JSON-in/JSON-out command interface with SELECT-only enforcement by default, parameterised queries, and passwords stored only in the OS credential manager. ## Core Features & Use Cases - Safe querying: Run SELECT queries with bound ? parameters, row caps, and a write guard that blocks INSERT/UPDATE/DDL unless --write is explicitly passed. - Schema introspection and mirroring: List tables and columns, extract every database object to local .sql files, and diff two mirrors or live databases. - Versioned migrations: Apply forward-only NNNN_slug.sql migrations tracked in dbo.__schema_migrations, with drift detection, danger warnings, and dry-run validation in rolled-back transactions. - Use Case: Ask the assistant to compare the schema of a dev database against a release database, then generate and dry-run a migration script before applying it to a sandbox environment. ## Quick Start Ask the assistant to run a read-only query such as "SELECT TOP 10 * FROM dbo.Customer" against the default SQL Server profile and return the rows as JSON.
