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

634

database-migrations-sql-migrations

SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, SQL Server

rmyndharis

databases

open

sql-databases

634

postgresql

Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features

rmyndharis

databases

open

sql-databases

619

Use when generating URL slugs in Stacks — creating unique slugs with database collision detection, the uniqueSlug function with table/column configuration, or basic slugification. Covers @stacksjs/slug.

stacksjs

databases

open

sql-databases

607

schema-builder

Design and generate Convex database schemas with proper validation, indexes, and relationships. Use when creating schema.ts or modifying table definitions.

waynesutton

databases

open

sql-databases

604

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

guanyang

databases

open

sql-databases

602

oma-db

Database specialist for SQL, NoSQL, and vector database modeling, schema design, normalization, indexing, transactions, integrity, concurrency control, backup, capacity planning, data standards, anti-pattern review, and compliance-aware database design. Use for database, schema, ERD, table design, document model, vector index design, RAG retrieval architecture, migration, query tuning, glossary, capacity estimation, backup strategy, database anti-pattern remediation work, and ISO 27001, ISO 27002, or ISO 22301-aware database recommendations.

first-fluke

databases

open

sql-databases

573

database-schema

Schema awareness - read before coding, type generation, prevent column errors

alinaqi

databases

open

sql-databases

565

duckdb-en

DuckDB CLI specialist for SQL analysis, data processing and file conversion. Use for SQL queries, CSV/Parquet/JSON analysis, database queries, or data conversion. Triggers on "duckdb", "sql", "query", "data analysis", "parquet", "convert data".

sundial-org

databases

open

sql-databases

565

schema-gen

Generate database schemas from descriptions

sundial-org

databases

open

sql-databases

565

sql-gen

Generate SQL queries from natural language

sundial-org

databases

open

sql-databases

552

pg-dump-reference

Consult PostgreSQL's pg_dump implementation for guidance on system catalog queries and schema extraction when implementing pgschema features

pgschema

databases

open

sql-databases

552

postgresql-syntax-reference

Consult PostgreSQL's parser and grammar (gram.y) to understand SQL syntax, DDL statement structure, and parsing rules when implementing pgschema features

pgschema

databases

open

sql-databases

552

validate-with-database

Connect to live PostgreSQL database to validate schema assumptions, compare pg_dump vs pgschema output, and query system catalogs interactively

pgschema

databases

open

sql-databases

550

hello-data

操作数据库、编写迁移、设计 schema、管理事务、创建索引、使用 Prisma/Sequelize/TypeORM/Mongoose 等 ORM，或执行 SQL/NoSQL 操作时使用。

hellowind777

databases

open

sql-databases

550

hello-perf

优化性能、处理数据库查询、实现缓存、懒加载、分页、打包优化，或代码涉及大数据集循环、并发操作、内存管理时使用。

hellowind777

databases

open

sql-databases

544

database-bigquery

Google BigQuery data warehouse queries and schema inspection. Use when running SQL queries, listing datasets/tables, or inspecting table schemas in BigQuery.

incidentfox

databases

open

sql-databases

544

database-postgresql

PostgreSQL database inspection and queries. Use when investigating table schemas, running queries, checking locks, replication status, or long-running queries.

incidentfox

databases

open

sql-databases

544