Mssql

Execute read-only SQL queries against multiple Microsoft SQL Server databases. Use when: (1) querying MSSQL/SQL Server databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.

448 stars 49 forksDatabases

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add sanjay3290/ai-skills --skill mssql
Manual install
git clone --depth 1 https://github.com/sanjay3290/ai-skills.git /tmp/ai-skills
mkdir -p ~/.claude/skills
cp -r /tmp/ai-skills/skills/mssql ~/.claude/skills/mssql

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# 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
Read the full skill on GitHub

Details

Skill name
mssql
Repository
sanjay3290/ai-skills
Path
skills/mssql/SKILL.md
License
Apache-2.0
Repo updated
10 September 2026
Listed in
BehiSecc/awesome-claude-skills, ComposioHQ/awesome-claude-skills, heilcheng/awesome-agent-skills, VoltAgent/awesome-agent-skills

FAQ

What does the Mssql skill do?

Execute read-only SQL queries against multiple Microsoft SQL Server databases. Use when: (1) querying MSSQL/SQL Server databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.

How do I install the Mssql skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add sanjay3290/ai-skills --skill mssql. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Mssql popular?

It lives in sanjay3290/ai-skills, which has 448 GitHub stars and 49 forks, and is included in 4 curated skill lists.

Related skills

Notebooklm

448

sanjay3290/ai-skills

Query and manage Google NotebookLM notebooks with persistent profile auth, source sync, batch/multi queries, and structured exports. Use when user asks to query NotebookLM, 'ask my notebook', shares NotebookLM notebook URLs, wants to list/create notebooks, manage sources, do bulk folder sync, dedupe, or audit exports.

Data & AnalyticsIn 4 lists49

Azure Devops

448

sanjay3290/ai-skills

Manage Azure DevOps projects, work items, repos, PRs, pipelines, wikis, test plans, security alerts, variable groups, environments/approvals, branch policies, and attachments. Use when user asks to: manage sprints, create/update work items, list repos, create PRs, run pipelines, search code, manage wiki pages, check security alerts, manage variable groups, approve deployments, or configure branch policies. Covers 13 domains with 99 tools via REST API.

DevOps & CloudIn 4 lists49

Deep Research

448

sanjay3290/ai-skills

Execute autonomous multi-step research using Google Gemini Deep Research Agent. Use for: market analysis, competitive landscaping, literature reviews, technical research, due diligence. Takes 2-10 minutes but produces detailed, cited reports. Costs $2-5 per task.

Research & ScienceIn 4 lists49

Mysql

448

sanjay3290/ai-skills

Execute read-only SQL queries against multiple MySQL databases. Use when: (1) querying MySQL databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.

DatabasesIn 4 lists49

Wx Favorites Report

642

zhuyansen/wx-favorites-report

微信收藏可视化：从加密的微信本地数据库端到端解密、解析，生成交互式 HTML 可视化报告。 触发词：/wx-favorites-report、微信收藏可视化、收藏报告、收藏分析 支持输入：加密/解密后的 Favorite.db（SQLite）或 CSV/JSON 导出文件

Databases134

PostgreSQL Queries

448

sanjay3290/ai-skills

Execute safe read-only SQL queries against PostgreSQL databases. Analyze and explore your database with Claude.

DatabasesIn 4 lists49

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.