skills.homescapability registry 搜尋

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

1

context-database-schema

Supabase PostgreSQL schema management, 86+ migrations, RLS policies, and type generation. Handles table creation, schema changes, migrations, foreign key constraints, and migration workflows. Use when working with database schema, migrations, data modeling, or type definitions, or when user mentions database changes, table modifications, schema updates, migration failures, "relation does not exist" errors, foreign key issues, Supabase schema operations, users table, accounts table, or holdings table.

stars-end

databases

sql-databases

1

postgresql-psql

Comprehensive guide for PostgreSQL psql - the interactive terminal client for PostgreSQL. Use when connecting to PostgreSQL databases, executing queries, managing databases/tables, configuring connection options, formatting output, writing scripts, managing transactions, and using advanced psql features for database administration and development.

akornmeier

databases

sql-databases

1

postgres-db

PostgreSQL database operations and management

oimiragieo

databases

sql-databases

1

database

Run SQL queries on connected database.

rakibdev

databases

sql-databases

1

postgresql-extensions

Essential PostgreSQL extensions - pg_stat_statements, pg_trgm, PostGIS

pluginagentmarketplace

databases

sql-databases

1

active-record-db

This skill should be used when the user asks about Active Record models, database migrations, queries, associations (belongs_to, has_many, has_one, has_and_belongs_to_many), validations, callbacks, scopes, database schema design, SQL optimization, N+1 queries, eager loading, joins, or database-specific features (PostgreSQL, MySQL, SQLite). Also use when discussing ORM patterns, data modeling, or database best practices. Examples:

sjnims

databases

sql-databases

1

gel

Gel (formerly EdgeDB) graph database schema design and querying. Use when designing Gel schemas, writing SDL, or querying with EdgeQL.

jasonkuhrt

databases

sql-databases

1

supabase-rest

Inspect Supabase database schemas and data. Use when the user asks to "check table", "list columns", or "query data" in Supabase. READ-ONLY.

lollipopkit

databases

sql-databases

1

backend-models

Define and structure database models and entities following data modeling best practices. Use this skill when creating or modifying model classes, entities, or database schema definitions. Use this skill when defining model relationships, associations, or foreign keys. Use this skill when implementing model validations, constraints, or data integrity rules. Use this skill when adding timestamps, indexes, or database-level constraints to models. Use this skill when choosing appropriate data types for model attributes. Use this skill when working with ORM model files, entity definitions, or database schema classes. Use this skill when establishing naming conventions for models and database tables.

TorbenMerrald

databases

sql-databases

1

mysql

MySQL DBA skill for schema design review, indexing, query performance tuning (EXPLAIN), transaction/isolation issues, replication/high availability, backup/restore, and operational checklists. Use for tasks like diagnosing slow queries, designing keys/indexes, partitioning strategy, and safe online schema changes.

muzhicaomingwang

databases

sql-databases

1

database-management

Implement SQLite database patterns using the database.py interface with complete SQL isolation. MANDATORY for all database projects. Use when working with databases, data persistence, or SQLite.

AutumnsGrove

databases

sql-databases

1

vanilla-rails-data-modeling

Use when designing database schema, writing migrations, or making data storage decisions - enforces UUIDs, account_id multi-tenancy, state-as-records, no foreign keys, and proper index patterns

ZempTime

databases

sql-databases

1

working-with-sqlite

Preferences and tricks for working with SQLite databases

williballenthin

databases

sql-databases

1

data-analyst-sql-optimization

Apply SQL optimization patterns including index usage, query rewriting, JOIN optimization, and window functions. Use when improving query performance or analyzing slow queries. This skill provides comprehensive SQL optimization patterns and best practices: - N+1 query elimination - Index optimization strategies - JOIN vs subquery performance - Window functions for complex aggregations - Query execution plan analysis Triggers: "optimize SQL", "slow query", "improve performance", "SQL最適化", "クエリ改善", "パフォーマンス向上"

takemi-ohama

databases

sql-databases

1

datomic

How to extract data from a Datomic database for maximum scalability and performance, with particular emphasis on leveraging standard query and indexes to get the best overall multiuser performance with emphasis on properly leveraging `d/q`, `d/index-pull`, `d/index-range`, `d/datoms` of the Clojure `datomic.client.api`.

saskenuba

databases

sql-databases

1

pg-doc-schema-review

Review and fix PRD/BP/tech design Markdown that includes PostgreSQL table DDL and API examples. Use to enforce these conventions: no auto-increment primary keys, no foreign keys, avoid join-based designs, unique constraints written with UNIQUE (not CREATE UNIQUE INDEX), detailed COMMENTs for tables/columns, and entity/aggregate-root tables include create_time and update_time.

muzhicaomingwang

databases

sql-databases

1

database-standard

Database design standards defining primary keys, foreign keys, audit fields, soft delete, junction tables. PostgreSQL style preferred, SQL lowercase without comments.

TrueNine

databases

sql-databases

1

drizzle-orm

Type-safe SQL with Drizzle ORM in TypeScript. Use when defining database schemas, writing queries, setting up relations, running migrations, or working with PostgreSQL/MySQL/SQLite/Cloudflare D1/Durable Objects data layers.

martinffx

databases

sql-databases

1

db-lint-manager

Lint PostgreSQL functions against schema, analyze usage, and generate fix reports; use when detecting broken functions, validating schema contracts, or cleaning up unused database functions

antoineschaller

databases

sql-databases

1

grdb

Use when writing raw SQL queries with GRDB, complex joins, ValueObservation for reactive queries, DatabaseMigrator patterns, query profiling under performance pressure, or dropping down from SQLiteData for performance - direct SQLite access for iOS/macOS

derKlinke

databases

sql-databases

1

developing-with-prisma

The agent implements Prisma ORM for type-safe database access with schema design, migrations, and queries. Use when building database layers, designing relational schemas, implementing type-safe queries, or managing database migrations.

doanchienthangdev

databases

sql-databases

1

database-optimization

Advanced database performance tuning including query optimization, indexing strategies, partitioning, and scaling patterns

doanchienthangdev

databases

sql-databases

1

database-schema-extension

Extend the Supabase PostgreSQL database schema following this project's declarative schema patterns, migration workflow, and type generation pipeline. Use when adding tables, columns, enums, RLS policies, triggers, or database functions.

Reodor-Studios

databases

sql-databases

1

postgresql-plpgsql

Write PL/pgSQL - functions, procedures, triggers, error handling

pluginagentmarketplace

databases

Page 65 / 81