SQL 데이터베이스

Postgres Schema Design

Comprehensive PostgreSQL-specific table design reference covering data types, indexing, constraints, performance patterns, and advanced features

davila724.7k

Using Neon

Guides and best practices for working with Neon Serverless Postgres. Covers getting started, local development with Neon, choosing a connection method, Neon features, authentication (@neondatabase/auth), PostgREST-style data API (@neondatabase/neon-js), Neon CLI, and Neon's Platform API/SDKs. Use for any Neon-related questions.

davila724.7k

Schema Exploration

Lists tables, describes columns and data types, identifies foreign key relationships, and maps entity relationships in a database. Use when the user asks about database schema, table structure, column types, what tables exist, ERD, foreign keys, or how entities relate.

langchain-ai21.2k

Sql Queries

Write correct, performant, readable SQL across all major data warehouse dialects.

kortix-ai19.6k

Bigquery Ai Ml

Skill for BigQuery AI and Machine Learning queries using standard SQL and `AI.*` functions (preferred over dedicated tools).

google19.1k

Transaction Correctness

How WAL mechanics, checkpointing, concurrency rules, recovery work in tursodb

tursodatabase18.3k

Storage Format

SQLite file format, B-trees, pages, cells, overflow, freelist that is used in tursodb

tursodatabase18.3k

Postgres Expert

PostgreSQL expert for query optimization, indexing, extensions, and database administration

Sql Analyst

SQL query expert for optimization, schema design, and data analysis

Mongodb

MongoDB operations expert for queries, aggregation pipelines, indexes, and schema design

Sqlite Expert

SQLite expert for WAL mode, query optimization, embedded patterns, and advanced features

Write Script Duckdb

MUST use when writing DuckDB queries.

Write Script Mysql

MUST use when writing MySQL queries.

Write Script Postgresql

MUST use when writing PostgreSQL queries.

Write Script Mssql

MUST use when writing MS SQL Server queries.

When to use

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.

prowler-cloud13.6k

Database Schema Designer

Use when the user asks to create ERD diagrams, normalize database schemas, design table relationships, or plan schema migrations.

alirezarezvani11.7k

Sql Database Assistant

Use when the user asks to write SQL queries, optimize database performance, generate migrations, explore database schemas, or work with ORMs like Prisma, Drizzle, TypeORM, or SQLAlchemy.

alirezarezvani11.7k

Write Query

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.

anthropics11.3k

Sql Queries

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

phuryn10.2k

Electric — Shape Streaming

Configure ShapeStream and Shape to sync a Postgres table to the client. Covers ShapeStreamOptions (url, table, where, columns, replica, offset, handle), custom type parsers (timestamptz, jsonb, int8), column mappers (snakeCamelMapper, createColumnMapper), onError retry semantics, backoff options, log modes (full, changes_only), requestSnapshot, fetchSnapshot, subscribe/unsubscribe, and Shape materialized view. Load when setting up sync, configuring shapes, parsing types, or handling sync errors.

electric-sql10.1k

Electric — Schema and Shapes

Design Postgres schema and Electric shape definitions together for a new feature. Covers single-table shape constraint, cross-table joins using multiple shapes, WHERE clause design for tenant isolation, column selection for bandwidth optimization, replica mode choice (default vs full for old_value), enum casting in WHERE clauses, and txid handshake setup with pg_current_xact_id() for optimistic writes. Load when designing database tables for use with Electric shapes.

electric-sql10.1k

Aws Dsql

Build with Aurora DSQL - manage schemas, execute queries, and handle migrations with DSQL-specific requirements. Use when developing a scalable or distributed database/application or user requests DSQL.

awslabs8.8k

digoal

Portable digital employee distilled from digoal's personal blog for PostgreSQL, PolarDB, DuckDB, AI+database, vector/RAG, database operations, source-code reading, technical content creation, open-source community strategy, and "德说" style strategic analysis. Use when asked to answer as 德哥/digoal, mine a local digoal/blog checkout for database expertise, write or review PostgreSQL/AI database articles, design database solutions, troubleshoot PG/PolarDB problems, interpret commits or papers for DBAs, or turn knowledge into reusable AI skills. Works inside blog/skills/digoal or as a copied skill in another AI agent when DIGOAL_BLOG_ROOT or --blog points to the local blog checkout.

digoal8.5k

Sqlite Schema Design

Design or review schemas for `crates/cloudsync` using SQLite Sync constraints, not generic SQLite advice. Use when adding synced tables, changing synced columns, or planning CloudSync-safe migrations.

fastrepl8.3k