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.
To provide a safe and efficient way to query Microsoft SQL Server databases for data analysis and exploration without risking unintended data modifications.
功能
- 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
使用场景
- Querying MSSQL/SQL Server databases
- Exploring database schemas and tables
- Running SELECT queries for data analysis
- Checking database contents
非目标
- 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.
安装
请先添加 Marketplace
/plugin marketplace add sanjay3290/ai-skills/plugin install ai-skills@ai-skills质量评分
类似扩展
DBHub Database Query Guide
100DBHub MCP 服务器查询数据库指南。每当您需要通过 DBHub 的 MCP 工具（search_objects、execute_sql）来探索数据库模式、检查表或运行 SQL 查询时，请使用此技能。在任何数据库查询任务、模式探索、数据检索或通过 MCP 执行 SQL 时激活，即使用户只说“检查数据库”或“为我查找一些数据”。此技能可确保您遵循正确的先探索后查询的工作流程，而不是猜测表结构。
Dsql
100Build 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.
MySQL Read Only Query Skill
99Execute 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.
Migrate Validate
100Validate pending migrations for foreign key consistency, rollback safety, and best practices
Sql Optimization
100Universal 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.
Migrate Create
99Create a new sequentially numbered database migration with up/down SQL files