home/categories/sql-databases

category focus

SQL

PostgreSQL, MySQL, and relational DBs.

1935 个技能all categories

sorting

stars

current ordering strategy

query

all entries

refine the visible subset

sql-databases

150.4K

postgres-patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

affaan-m

databases

open

sql-databases

150.4K

postgres-patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

affaan-m

databases

open

sql-databases

150.4K

postgres-patterns

쿼리 최적화, 스키마 설계, 인덱싱, 보안을 위한 PostgreSQL 데이터베이스 패턴. Supabase 모범 사례 기반.

affaan-m

databases

open

sql-databases

150.4K

postgres-patterns

Sorgu optimizasyonu, şema tasarımı, indeksleme ve güvenlik için PostgreSQL veritabanı kalıpları. Supabase en iyi uygulamalarına dayanır.

affaan-m

databases

open

sql-databases

150.4K

clickhouse-io

ClickHouse数据库模式、查询优化、分析以及高性能分析工作负载的数据工程最佳实践。

affaan-m

databases

open

sql-databases

150.4K

jpa-patterns

Spring Boot中的JPA/Hibernate模式，用于实体设计、关系处理、查询优化、事务管理、审计、索引、分页和连接池。

affaan-m

databases

open

sql-databases

150.4K

postgres-patterns

用于查询优化、模式设计、索引和安全性的PostgreSQL数据库模式。基于Supabase最佳实践。

affaan-m

databases

open

sql-databases

150.4K

Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Django, TypeORM, golang-migrate). Use when planning or implementing database schema changes.

affaan-m

databases

open

sql-databases

150.4K

postgres-patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Quick reference for common patterns, index types, data types, and anti-pattern detection. Based on Supabase best practices.

affaan-m

databases

open

sql-databases

150.4K

database-migrations

affaan-m

databases

open

sql-databases

150.4K

postgres-patterns

PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.

affaan-m

databases

open

sql-databases

52.5K

create-database-migration

Create a database migration to add a table, add columns to an existing table, add a setting, or otherwise change the schema of Ghost's MySQL database. Use this skill whenever the task involves modifying Ghost's database schema — including adding, removing, or renaming columns or tables, adding new settings, creating indexes, updating data, or any change that requires a migration file in ghost/core. Also use when the user references schema.js, knex-migrator, the migrations directory, or asks to "add a field" or "add a column" to any Ghost model/table. Even if the user frames it as a feature or Linear issue, if the implementation requires a schema change, this skill applies.

TryGhost

databases

open

sql-databases

33.4K

database-migration

Execute database migrations across ORMs and platforms with zero-downtime strategies, data transformation, and rollback procedures. Use when migrating databases, changing schemas, performing data transformations, or implementing zero-downtime deployment strategies.

wshobson

databases

open

sql-databases

33.4K

postgresql-table-design

Use this skill when designing or reviewing a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features

wshobson

databases

open

sql-databases

32.1K

sqlmap-database-pentesting

Provide systematic methodologies for automated SQL injection detection and exploitation using SQLMap.

sickn33

databases

open

sql-databases

32.1K

postgres-best-practices

Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

sickn33

databases

open

sql-databases

32.1K