Write Query
Skill ActiveWrite optimized SQL for your dialect with best practices. Use when translating a natural-language data need into SQL, building a multi-CTE query with joins and aggregations, optimizing a query against a large partitioned table, or getting dialect-specific syntax for Snowflake, BigQuery, Postgres, etc.
To empower users to easily translate natural language data requirements into accurate, optimized, and dialect-specific SQL queries.
Features
- Write optimized SQL for your dialect
- Translate natural-language data needs into SQL
- Build multi-CTE queries with joins and aggregations
- Optimize queries against large partitioned tables
- Provide dialect-specific syntax for Snowflake, BigQuery, Postgres, etc.
Use Cases
- Translating a natural-language data need into SQL
- Building a multi-CTE query with joins and aggregations
- Optimizing a query against a large partitioned table
- Getting dialect-specific syntax for Snowflake, BigQuery, Postgres, etc.
Non-Goals
- Executing SQL queries directly (unless a connected MCP server supports it)
- Providing a general-purpose SQL client
- Writing complex stored procedures or triggers
Trust
- warning:Issues Attention29 issues opened and 4 closed in the last 90 days indicates a low closure rate and potentially slow response times from maintainers.
Portability
- info:Cross-skill couplingThe SKILL.md mentions CONNECTORS.md, indicating potential reliance on external context, but this is explicit and optional.
Installation
First, add the marketplace
/plugin marketplace add anthropics/knowledge-work-plugins/plugin install data@knowledge-work-pluginsQuality Score
Trust Signals
Similar Extensions
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 Validate
100Validate pending migrations for foreign key consistency, rollback safety, and best practices
MongoDB Connection Optimizer
100Optimize MongoDB client connection configuration (pools, timeouts, patterns) for any supported driver language. Use this skill when working/updating/reviewing on functions that instantiate or configure a MongoDB client (eg, when calling `connect()`), configuring connection pools, troubleshooting connection errors (ECONNREFUSED, timeouts, pool exhaustion), optimizing performance issues related to connections. This includes scenarios like building serverless functions with MongoDB, creating API endpoints that use MongoDB, optimizing high-traffic MongoDB applications, creating long-running tasks and concurrency, or debugging connection-related failures.
DBHub Database Query Guide
100Guide 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.
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.
Migrate Create
99Create a new sequentially numbered database migration with up/down SQL files