SQL skills

SQL Database Assistant

alirezarezvani

Streamline your SQL tasks and optimize database performance.

SQL Queries

anthropics

Write and optimize SQL across major data warehouse dialects.

Querying PostHog Data

posthog

Efficiently query and analyze your PostHog data.

Database Workflow Bundle

sickn33

Streamline your database design and operations.

ClickHouse Query

civitai

Run ClickHouse queries for analytics and metrics analysis.

ClickHouse Query Performance Reports

posthog

Generate structured reports for slow ClickHouse queries.

Neon Instagres

davila7

Provision production-ready Postgres databases in seconds.

BigQuery Basics

google

Effortlessly manage datasets and run SQL queries in BigQuery.

Go Database Access

samber

Master safe and efficient database interactions in Go.

Retool Database Query

civitai

Effortlessly query Retool's PostgreSQL database.

Database Index Advisor

jeremylongshore

Optimize your database indexing for better performance.

Querying Local Postgres

posthog

Run read-only SQL queries against your local Postgres database.

BigQuery AI & ML

google

Leverage BigQuery's AI for advanced data analytics.

ClickHouse Migrations

posthog

Streamline your ClickHouse migration processes with best practices.

Database Schema Designer

davila7

Create robust database schemas effortlessly.

ClickHouse Analytics Patterns

sickn33

Optimize your ClickHouse queries and data structures.

SQL Pro

davila7

Master advanced SQL techniques for cloud-native databases.

Write, review, and migrate Supabase logs queries against the ClickHouse-backed `logs` table (the `logs.all.otel` analytics endpoint). Use this whenever a task involves Logs Explorer SQL, the `log_attributes` map, querying a log `source` (edge_logs, postgres_logs, auth_logs, etc.), translating an old BigQuery `cross join unnest(metadata)` logs query to ClickHouse, or wiring analytics log SQL in `apps/studio/data/logs` and `apps/studio/components/interfaces/Settings/Logs`. Reach for it even when the user just says "logs query", "Logs Explorer", or pastes a BigQuery logs query to convert, not only when they name ClickHouse.

PostgreSQL indexing best practices for Prowler: index design, partial indexes, partitioned table indexing, EXPLAIN ANALYZE validation, concurrent operations, monitoring, and maintenance. Trigger: When creating or modifying PostgreSQL indexes, analyzing query performance with EXPLAIN, debugging slow queries, reviewing index usage statistics, reindexing, dropping indexes, or working with partitioned table indexes. Also trigger when discussing index strategies, partial indexes, or index maintenance operations like VACUUM or ANALYZE.

Query Playwright CI test results from the aggregated DuckDB database. Answers questions about flaky tests, failure rates, slow tests, and per-run/SHA/PR results without hunting through GitHub artifacts.

PostgreSQL-specific development assistant focusing on unique PostgreSQL features, advanced data types, and PostgreSQL-exclusive capabilities. Covers JSONB operations, array types, custom types, range/geometric types, full-text search, window functions, and PostgreSQL extensions ecosystem.

Write 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.

Use when the user asks to design database schemas, plan data migrations, optimize queries, choose between SQL and NoSQL, or model data relationships.