Skip to main content

Mssql

Skill Active
Part of:Ai Skills

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.

Purpose

To provide a safe and efficient way to query Microsoft SQL Server databases for data analysis and exploration without risking unintended data modifications.

Features

  • Execute read-only SQL queries
  • Support for multiple MSSQL database connections
  • Intelligent database auto-selection based on description
  • Query validation and write operation blocking
  • List databases, tables, and schemas

Use Cases

  • Querying MSSQL/SQL Server databases
  • Exploring database schemas and tables
  • Running SELECT queries for data analysis
  • Checking database contents

Non-Goals

  • Performing write operations (INSERT, UPDATE, DELETE, DROP)
  • Executing multi-statement queries
  • Connecting to databases other than MSSQL

Maintenance

  • warning:Dependency ManagementThe skill uses the `pymssql` dependency but there is no explicit mention of dependency vulnerability checks or an automated update mechanism like Dependabot.

Execution

  • warning:Pinned dependenciesWhile `pymssql` is required and listed in `requirements.txt`, there is no lockfile present to pin specific versions of dependencies.

Installation

First, add the marketplace

/plugin marketplace add sanjay3290/ai-skills
/plugin install ai-skills@ai-skills

Quality Score

95 /100
Analyzed about 18 hours ago

Trust Signals

Last commit7 days ago
Stars272
LicenseApache-2.0
Status
View Source

Similar Extensions

DBHub Database Query Guide

100

Guide for querying databases through DBHub MCP server. Use this skill whenever you need to explore database schemas, inspect tables, or run SQL queries via DBHub's MCP tools (search_objects, execute_sql). Activates on any database query task, schema exploration, data retrieval, or SQL execution through MCP — even if the user just says "check the database" or "find me some data." This skill ensures you follow the correct explore-first workflow instead of guessing table structures.

Skill
bytebase

Dsql

100

Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL operations, query plan explainability, and SQL compatibility validation. Triggers on phrases like: DSQL, Aurora DSQL, create DSQL table, DSQL schema, migrate to DSQL, distributed SQL database, serverless PostgreSQL-compatible database, DSQL query plan, DSQL EXPLAIN ANALYZE, why is my DSQL query slow.

Skill
awslabs

MySQL Read Only Query Skill

99

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.

Skill
sanjay3290

Migrate Validate

100

Validate pending migrations for foreign key consistency, rollback safety, and best practices

Skill
ruvnet

Sql Optimization

100

Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.

Skill
github

Migrate Create

99

Create a new sequentially numbered database migration with up/down SQL files

Skill
ruvnet

© 2025 SkillRepo · Find the right skill, skip the noise.