skills.homescapability registry Search

home/categories/sql-databases

category focus

SQL

PostgreSQL, MySQL, and relational DBs.

1935 skillsall categories

sorting

stars

current ordering strategy

query

all entries

refine the visible subset

sql-databases

54

go-database

Database patterns for Go services: database/sql, connection management, transactions, migrations, query builders, and ORM usage (sqlc, GORM, ent). Use when: "database access", "SQL query", "connection pool", "transactions", "database migration", "sqlc", "GORM", "ent", "prepared statement", "repository pattern". Do NOT use for: in-memory data structures (use go-coding-standards), security aspects of SQL (use go-security-audit), or performance profiling of queries (use go-performance-review).

eduardo-sl

databases

sql-databases

54

postgresql-query

Execute SQL queries, manage schemas, and perform data operations using PostgreSQL at {{POSTGRES_HOST}}:{{POSTGRES_PORT}}.

bidewio

databases

sql-databases

54

db-migration

指导同时为 MySQL 和 SQL Server 创建数据库迁移。使用数据库特定的 DbContext，处理数据库差异，配置雪花ID。当用户需要创建迁移、修改实体、或遇到迁移错误时使用。

xin-lai

databases

sql-databases

53

database-architect

Database design specialist for schema modeling, query optimization, indexing strategies, and data integrityUse when "database design, schema, indexes, query optimization, migrations, normalization, database scaling, foreign keys, data modeling, database, sql, postgres, mysql, mongodb, schema, indexes, migrations, normalization, optimization" mentioned.

omer-metin

databases

sql-databases

53

database-migrations

Expert at evolving database schemas safely. Covers migration strategies, zero-downtime deployments, rollback planning, and data transformation. Knows how to change production schemas without breaking running applications. Use when "database migration, schema change, add column, alter table, drizzle migrate, prisma migrate, zero downtime migration, rollback migration, database, migrations, schema, drizzle, prisma, postgresql, zero-downtime" mentioned.

omer-metin

databases

sql-databases

53

drizzle-orm

Expert knowledge for Drizzle ORM - the lightweight, type-safe SQL ORM for edge and serverlessUse when "drizzle, drizzle orm, drizzle-kit, drizzle schema, drizzle migration, drizzle relations, sql orm typescript, edge database, d1 database, orm, database, typescript, sql, edge, serverless, d1, postgres, mysql, sqlite" mentioned.

omer-metin

databases

sql-databases

53

postgres-nio

Expert guidance on using PostgreSQL with Swift. Use when developers mention: (1) PostgreSQL or Postgres in Swift, (2) postgres-nio library, (3) SQL queries in Swift, (4) PostgreSQL connection pooling, (5) prepared statements, (6) type-safe database access, (7) bulk loading or COPY FROM, (8) PostgresClient or PostgresConnection.

wendylabsinc

databases

sql-databases

53

supabase-security

Deep expertise in securing Supabase applications. Covers Row Level Security (RLS) patterns, auth token validation, storage security, multi-tenant isolation. Use when "supabase security, rls policy, row level security, service role key, multi-tenant rls, supabase, security, rls, postgres" mentioned.

omer-metin

databases

sql-databases

53

database-schema-design

World-class database schema design - data modeling, migrations, relationships, and the battle scars from scaling databases that store billions of rowsUse when "database schema, data model, migration, prisma schema, drizzle schema, create table, add column, foreign key, primary key, uuid, auto increment, soft delete, normalization, denormalization, one to many, many to many, junction table, polymorphic, enum type, index strategy, database, schema, migration, data-model, prisma, drizzle, typeorm, postgresql, mysql, sqlite" mentioned.

omer-metin

databases

sql-databases

53

neon-postgres

Expert patterns for Neon serverless Postgres, branching, connection pooling, and Prisma/Drizzle integrationUse when "neon database, serverless postgres, database branching, neon postgres, postgres serverless, connection pooling, preview environments, database per preview, neon, postgres, serverless, database, branching, prisma, drizzle, connection-pooling" mentioned.

omer-metin

databases

sql-databases

53

supabase-backend

Expert knowledge for Supabase database, RLS, and backend patternsUse when "supabase, row level security, rls, postgres, database policy, supabase storage, supabase realtime, supabase, postgres, rls, database, backend, storage, realtime" mentioned.

omer-metin

databases

sql-databases

53

performance-hunter

Performance optimization specialist for profiling, caching, and latency optimizationUse when "performance, latency, slow query, profiling, caching, optimization, N+1, connection pool, p99, performance, profiling, caching, latency, optimization, async, database, load-testing, ml-memory" mentioned.

omer-metin

databases

sql-databases

53

postgres-migration

Creates an Alembic migration script for PostgreSQL database schema changes. Use this skill when database models in `packages/postgres-database/src/simcore_postgres_database/models/` have changed (column additions, type changes, schema structure modifications, etc.).

ITISFoundation

databases

sql-databases

52

migration-patterns

Database migration creation with mandatory RLS policies and ARCHitect approval workflow. Use when creating migrations, adding tables with RLS, or updating Prisma schema.

bybren-llc

databases

sql-databases

52

migration-patterns

Database migration creation with mandatory RLS policies and ARCHitect approval workflow. Use when creating migrations, adding tables with RLS, or updating Prisma schema.

bybren-llc

databases

sql-databases

52

rls-patterns

Row Level Security patterns for database operations. Use when writing Prisma/database code, creating API routes that access data, or implementing webhooks. Enforces withUserContext, withAdminContext, or withSystemContext helpers. NEVER use direct prisma calls.

bybren-llc

databases

sql-databases

52

rls-patterns

Row Level Security patterns for database operations. Use when writing Prisma/database code, creating API routes that access data, or implementing webhooks. Enforces withUserContext, withAdminContext, or withSystemContext helpers. NEVER use direct prisma calls.

bybren-llc

databases

sql-databases

52

sql-cookbook

Craft and optimize SQL for any warehouse dialect — Snowflake, BigQuery, Databricks, Redshift, PostgreSQL. Covers window functions, CTEs, aggregations, joins, funnel queries, cohort retention, deduplication, dialect translation, slow query tuning, and cross-platform syntax differences.

vm0-ai

databases

sql-databases

51

database-administrator

Expert database administrator specializing in high-availability systems, performance optimization, and disaster recovery. Masters PostgreSQL, MySQL, MongoDB, and Redis with focus on reliability, scalability, and operational excellence.

zenobi-us

databases

sql-databases

51

sql-pro

Expert SQL developer specializing in complex query optimization, database design, and performance tuning across PostgreSQL, MySQL, SQL Server, and Oracle. Masters advanced SQL features, indexing strategies, and data warehousing patterns.

zenobi-us

databases

sql-databases

51

database-schema-design

Design normalized database schemas with tables, relationships, indexes, and migrations

Xiaowen-Jiang

databases

sql-databases

51

postgres-pro

Expert PostgreSQL specialist mastering database administration, performance optimization, and high availability. Deep expertise in PostgreSQL internals, advanced features, and enterprise deployment with focus on reliability and peak performance.

zenobi-us

databases

sql-databases

50

alembic

Comprehensive Alembic database migration management for customer support systems

manutej

databases

sql-databases

50

postgresql-database-administration

Comprehensive PostgreSQL database administration skill for customer support tech enablement, covering database design, optimization, performance tuning, backup/recovery, and advanced query techniques

manutej

databases

Page 29 / 81