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

backend-migrations

Create and manage Prisma database migrations for schema changes in PostgreSQL. Use this skill when modifying Prisma schema files (*.prisma), creating new database migrations, adding or modifying database tables/columns/indexes, managing foreign key relationships, or running migration commands. This includes files in prisma/schema/ directory (schema.prisma, member.prisma, article.prisma, series.prisma, tag.prisma, article-comment.prisma), and migration files in prisma/migrations/. Apply when using Prisma CLI commands like `prisma migrate dev`, `prisma generate`, `prisma db push`, or when restructuring the split schema architecture.

imkdw

databases

sql-databases

1

sqldown

Bidirectional markdown ↔ SQLite conversion with column limit protection and smart section extraction. Import with Python, query with sqlite3.

mbailey

databases

sql-databases

1

database-operations

PostgreSQL database patterns and Data Gateway compliance

TalkingMonkeyOz

databases

sql-databases

1

query-optimization

SQL query optimization and performance tuning

pluginagentmarketplace

databases

sql-databases

1

database-expert

Database performance optimization, schema design, query analysis, and connection management across PostgreSQL, MySQL, MongoDB, and SQLite with ORM integration. Use this skill for queries, indexes, connection pooling, transactions, and database architecture decisions.

ANHDOO

databases

sql-databases

1

creating-migrations

Create Laravel database migrations following conventions for schema changes, indexes, and foreign keys. Use when creating migrations, modifying database schema, adding tables, or when user mentions migrations, database schema, schema changes, or database structure.

moonpixels

databases

sql-databases

1

migrations

Database schema migrations and version control

pluginagentmarketplace

databases

sql-databases

1

database-optimizer

Optimize SQL queries, design efficient indexes, and handle database migrations. Solves N+1 problems, slow queries, and implements caching. Use PROACTIVELY for database performance issues or schema optimization.

sidetoolco

databases

sql-databases

1

supabase-prisma-database-management

This skill should be used when managing database schema, migrations, and seed data using Prisma ORM with Supabase PostgreSQL. Apply when setting up Prisma with Supabase, creating migrations, seeding data, configuring shadow database for migration preview, adding schema validation to CI, or managing database changes across environments.

hopeoverture

databases

sql-databases

1

flyway-migrations

Flyway database migrations - use for schema changes, data migrations, version management, and PostgreSQL DDL

ashchupliak

databases

sql-databases

1

mongodb-expert

MongoDB document modeling, aggregation pipeline optimization, sharding strategies, replica set configuration, connection pool management, and indexing patterns. Use this skill for MongoDB-specific issues, NoSQL performance optimization, and schema design.

ANHDOO

databases

sql-databases

1

agentuity-cli-cloud-db-sql

Execute SQL query on a database. Requires authentication. Use for Agentuity cloud platform operations

agentuity

databases

sql-databases

1

postgresql-advanced-queries

Master advanced PostgreSQL queries - CTEs, window functions, recursive queries

pluginagentmarketplace

databases

sql-databases

1

postgresql

PostgreSQL database design, queries, optimization, and best practices

doanchienthangdev

databases

sql-databases

1

oracle-dba

Oracle DBA and DevOps expertise for Autonomous Database (ADB) on OCI. This skill should be used when managing Oracle Autonomous Databases, writing optimized SQL/PLSQL, configuring security (TDE, Database Vault, Data Safe), implementing HA/DR (Data Guard, PITR), using OCI CLI for database operations, or integrating with Oracle MCP servers for AI-assisted database management. Covers Oracle Database versions 19c, 21c, 23ai, and 26ai.

acedergren

databases

sql-databases

1

data-and-sql

Use when writing SQL queries, optimizing database performance, or analyzing data

trash-panda-v91-beta

databases

sql-databases

1

db-query

Execute database queries using PostgreSQL MCP. Use when users want to run SQL queries, analyze data, check schema, or optimize queries.

This-HW

databases

sql-databases

1

postgres-setup

Set up PostgreSQL database with standardized schema.sql pattern. Use when starting a new project that needs PostgreSQL, setting up database schema, or creating setup scripts for postgres.

jmazzahacks

databases

sql-databases

1

supabase-fallback

Supabase DB 직접 접근. Use when (1) "DB 조회/수정", "테이블 데이터", (2) 온프레미스 Supabase PostgREST API, (3) Spring 미가동 시 fallback.

semicolon-devteam

databases

sql-databases

1

create-collection

Use this skill when you need to alter the PocketBase database schema - creating, updating, or deleting collections. Never write migration SQL by hand.

levino

databases

sql-databases

1

postgresql-backup

PostgreSQL backup and recovery - pg_dump, pg_basebackup, PITR

pluginagentmarketplace

databases

sql-databases

1

prisma-relations-mapping

CRITICAL: Use this skill when working with Prisma database models, API routes with includes/relations, or debugging "500 errors", "relation not found", "undefined from backend" errors. AUTO-ACTIVATE when user mentions (FR/EN): - prisma, relation, relations, mapping, PascalCase, camelCase - API 500, erreur 500, backend error, erreur backend - undefined, null, relation introuvable, relation not found - créer API, create API, endpoint, route API - include, select, findMany, findUnique, create, update - OperatingRoom, OperatingSector, Personnel, Assignment, Site This skill contains the COMPLETE mapping table for post-PascalCase migration (Oct 26, 2025). ALL 121 models with correct relation names and required fields.

vperreard

databases

sql-databases

1

dbc-schema

Generate Effect Schema definitions for WoW DBC tables. Use when adding new game data tables or updating existing schemas.

legacy3

databases

sql-databases

1

sql-fundamentals

Master SQL fundamentals including SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP operations. Learn data types, WHERE clauses, ORDER BY, GROUP BY, and basic joins.

pluginagentmarketplace

databases

Page 63 / 81