mssql

# MSSQL Read-Only Query Skill Execute safe, read-only queries against configured Microsoft SQL Server databases. ## Requirements - Python 3.8+ - pymssql: `pip install -r requirements.txt` ## Setup Create `connections.json` in the skill directory or `~/.config/claude/mssql-connections.json`. **Security**: Set file permissions to `600` since it contains credentials: ```bash chmod 600 connections.json ``` ```json { "databases": [ { "name": "production", "description": "Main app database - users, orders, transactions", "host": "db.example.com", "port": 1433, "database": "app_prod", "user": "readonly_user", "password": "your-password", "encrypt": true, "tds_version": "7.3" } ] } ``` ### Config Fields | Field | Required | Description | |-------|----------|-------------| | name | Yes | Identifier for the database (case-insensitive) | | description | Yes | What data this database contains (used for auto-selection) | | host | Yes | Database hostname | | port | No | Port number (default: 1433) | | database | Yes | Database name | | user | Yes | Username | | password | Yes | Password | | encrypt | No | Enable TLS encryption (default: false) | | tds_version | No | TDS protocol version: 7.0, 7.1, 7.2, 7.3, 7.4 (default: auto) | ## Usage ### List configured databases ```bash python3 scripts/query.py --list ``` ### Query a database ```bash python3 scripts/query.py --db production --query "SELECT TOP 10 * FROM user...