Sql Queries
技能 活跃Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.). Use when writing queries, optimizing slow SQL, translating between dialects, or building complex analytical queries with CTEs, window functions, or aggregations.
To help users write and optimize SQL queries efficiently across various data warehouse platforms by providing accurate syntax, best practices, and illustrative examples.
功能
- SQL generation for multiple data warehouse dialects
- Dialect-specific syntax and function references
- Performance optimization tips for each dialect
- Examples of common SQL patterns (window functions, CTEs, etc.)
- Guidance on error handling and debugging SQL
使用场景
- Writing new SQL queries for diverse data warehouses
- Optimizing existing slow-performing SQL statements
- Translating SQL queries between different dialects
- Building complex analytical queries with advanced SQL features
非目标
- Executing SQL queries directly
- Managing database infrastructure or schema
- Providing real-time database monitoring
- Writing SQL for NoSQL databases
Trust
- warning:Issues AttentionIn the last 90 days, 29 issues were opened and 4 were closed, indicating a low closure rate and slow maintainer response.
安装
请先添加 Marketplace
/plugin marketplace add anthropics/knowledge-work-plugins/plugin install data@knowledge-work-plugins质量评分
类似扩展
SQL Query Generator
98Generate SQL queries from natural language descriptions. Supports BigQuery, PostgreSQL, MySQL, and other dialects. Reads database schemas from uploaded diagrams or documentation. Use when writing SQL, building data reports, exploring databases, or translating business questions into queries.
Ga4 Bigquery Schema
99GA4 BigQuery Export Schema Reference — complete field reference, nested structures, query patterns, and performance tips
Postgresql Table Design
98Use this skill when designing or reviewing a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
PostgreSQL Pro
98Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features. Invoke for EXPLAIN analysis, JSONB operations, extension usage, VACUUM tuning, performance monitoring.
Azure Postgres Ts
100Connect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package. Use for PostgreSQL queries, connection pooling, transactions, and Microsoft Entra ID (passwordless) authentication. Triggers: "PostgreSQL", "postgres", "pg client", "node-postgres", "Azure PostgreSQL connection", "PostgreSQL TypeScript", "pg Pool", "passwordless postgres".
Senior Backend Engineer
100Designs and implements backend systems including REST APIs, microservices, database architectures, authentication flows, and security hardening. Use when the user asks to "design REST APIs", "optimize database queries", "implement authentication", "build microservices", "review backend code", "set up GraphQL", "handle database migrations", or "load test APIs". Covers Node.js/Express/Fastify development, PostgreSQL optimization, API security, and backend architecture patterns.