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

0

backend-queries

Write efficient, secure database queries using parameterized queries, eager loading, and performance optimizations. Use this skill when writing database queries, implementing data retrieval logic, using ORM query builders, writing raw SQL queries, implementing eager loading or joins, preventing N+1 query problems, implementing query filters or search functionality, using transactions for data consistency, implementing pagination queries, optimizing slow queries, implementing query caching, working with query builder methods, or writing repository/DAO layer code. Use when working with SQL queries, ORM query builders like Sequelize, TypeORM, Prisma, SQLAlchemy, ActiveRecord, Django ORM query APIs, or raw database access code.

tlabs-xyz

databases

sql-databases

0

mysql-optimization

MySQL performance optimization guide for Spring Boot/JPA. Use when reviewing database code, discussing index design, query optimization, N+1 problems, JPA/Hibernate tuning, or analyzing EXPLAIN plans. Complements /mysql-performance and /optimize-query commands.

xinqilin

databases

sql-databases

0

convex-queries

Best practices for Convex database queries, indexes, and filtering. Use when writing or reviewing database queries in Convex, working with `.filter()`, `.collect()`, `.withIndex()`, defining indexes in schema.ts, or optimizing query performance.

aaronvanston

databases

sql-databases

0

hive-schema

How to create database schemas in Hive framework

paralect

databases

sql-databases

0

database-optimization

Optimize SQL queries, analyze indexes, review Alembic migrations, and identify N+1 problems. Provides query execution plans, index recommendations, and migration best practices for SQLAlchemy async.

ils15

databases

sql-databases

0

backend-migrations

Create and manage database migrations following best practices for reversibility, zero-downtime deployments, and safe schema changes. Use this skill when creating new database migrations, writing migration up/down methods, implementing schema changes (adding/removing tables, columns, indexes, constraints), performing data migrations or transformations, refactoring database structure, implementing backwards-compatible migrations, creating indexes on large tables, renaming database objects, or working with migration files in directories like migrations/, db/migrate/, alembic/versions/, or similar. Use when working with ORMs like Sequelize, TypeORM, Prisma, SQLAlchemy, ActiveRecord, Django ORM, or raw SQL migration files.

tlabs-xyz

databases

sql-databases

0

database-change-management

Plan and implement safe database schema changes including migrations, indexes, and backfills. Use when creating tables, adding columns, optimizing queries, or managing Eloquent/SQLAlchemy relationships. EXCLUSIVE to database-admin agent.

htooayelwinict

databases

sql-databases

0

databases

Work with MongoDB (document database, BSON documents, aggregation pipelines, Atlas cloud) and PostgreSQL (relational database, SQL queries, psql CLI, pgAdmin). Use when designing database schemas, writing queries and aggregations, optimizing indexes for performance, performing database migrations, configuring replication and sharding, implementing backup and restore strategies, managing database users and permissions, analyzing query performance, or administering production databases.

kiet-ta

databases

sql-databases

0

sql-server-dba-dev-expert

Use when designing, implementing, optimizing, or troubleshooting AF.ECT.Database schemas, queries, stored procedures, performance tuning, data integrity, or operational database tasks while following Microsoft best practices

donellmccoy

databases

sql-databases

0

postkit

PostgreSQL-native identity, configuration, and metering. Use when working with user management, sessions, permissions, access control, login/logout, MFA, password resets, role-based access, versioned configuration, prompts, feature flags, secrets, usage tracking, quotas, or billing periods in PostgreSQL. Covers authn (user/session management), authz (ReBAC permissions), config (versioned key-value storage), and meter (usage tracking with reservations).

varunchopra

databases

sql-databases

0

schema-architect

Designs database schemas with multi-tenancy, relationships, and best practices. Triggers when user needs to design data model, create entities, or plan database structure.

mavric

databases

sql-databases

0

safe-migrate

Safely creates and applies database migrations with automatic destructive operation detection, backup creation, and rollback generation. This skill should be used when creating database migrations, applying schema changes, or performing any database DDL operations. Essential for preventing data loss.

creepyblues

databases

sql-databases

0

sqlmodel-db-expert

Expert in designing SQLModel schemas and managing Neon PostgreSQL databases. Use this when defining data models, handling relationships, or performing database migrations.

hammadurrehman2006

databases

sql-databases

0

altinity-expert-clickhouse-merges

Diagnose ClickHouse merge performance, part backlog, and 'too many parts' errors. Use for merge issues and part management problems.

Altinity

databases

sql-databases

0

prisma-patterns

Prisma schema conventions, migrations, and query patterns for TaxHelper. Use when modifying the database schema, writing complex queries, or optimizing database access.

mattleonard16

databases

sql-databases

0

query-optimization

Automatically applies when optimizing database queries. Ensures EXPLAIN analysis, proper indexing, N+1 prevention, query performance monitoring, and efficient SQL patterns.

ricardoroche

databases

sql-databases

0

hive-database

Database operations in Hive framework

paralect

databases

sql-databases

0

backend-queries

Write optimized and secure database queries using parameterized queries, eager loading, and proper indexing strategies. Use this skill when writing database queries, constructing SQL statements, using ORM query methods, implementing data fetching logic, preventing SQL injection attacks, optimizing query performance, avoiding N+1 query problems, selecting specific columns instead of all data, implementing transactions for related operations, setting query timeouts, caching expensive queries, or working with WHERE clauses, JOINs, and ORDER BY statements. Apply this skill when fetching data from databases, optimizing slow queries, refactoring data access code, or reviewing query security and performance.

pdovhomilja

databases

sql-databases

0

backend-queries

Write secure, optimized database queries using parameterized statements, proper indexing, and efficient data fetching patterns. Use this skill when writing database queries, ORM query methods, SQL statements, or data access layer code. When working on files containing Prisma queries, TypeORM query builders, raw SQL statements, database transaction logic, eager loading and joins, query optimization code, files implementing data pagination or filtering, cache strategies for expensive queries, or files handling database connection pooling and query timeouts.

SpacePlushy

databases

sql-databases

0

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.

ccf

databases

sql-databases

0

databricks-query

Execute SQL queries against Databricks using the DBSQL MCP server. Use when querying Unity Catalog tables, running SQL analytics, exploring Databricks data, or when user mentions Databricks queries, SQL execution, Unity Catalog, or data warehouse operations. Handles query execution, result formatting, and error handling.

fusionet24

databases

sql-databases

0

duckdb-backup

Comprehensive DuckDB database backup toolkit supporting both file-based (cp) and native (ATTACH+COPY) backup approaches. Use when you need to backup DuckDB databases locally or to remote storage, create daily scheduled backups, verify backup integrity, or manage backup retention policies.

goodluckz

databases

sql-databases

0

backend-models

Define database models and schemas with proper data types, constraints, relationships, and validation rules for PostgreSQL (Supabase/Bun.sql) and Firestore (Firebase). Use this skill when creating or modifying database models, ORM entity definitions, Prisma schemas, or Firestore document structures. Apply when working on model files (models/*.ts, entities/*.ts, schema.prisma, models/*.py, Models/*.cs), defining database relationships, setting up validation rules, or implementing data integrity constraints. This skill ensures snake_case naming for SQL and camelCase for NoSQL, required timestamps (created_at/updated_at), UUIDs for SQL and auto-generated IDs for Firestore, foreign key constraints with indexed columns, Row Level Security (RLS) policies for Supabase, strict Firestore security rules, normalized data for SQL (3NF) with denormalization for Firestore read performance, and pgvector setup for AI embeddings.

TheophilusChinomona

databases

sql-databases

0

supabase-database

Supabase database operations including queries, CRUD operations, RLS policies, and PostgreSQL functions. Use when querying tables, managing data, implementing RLS, or writing database functions.

adaptationio

databases

Page 69 / 81