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

data-modeling

Firestore 데이터 모델링과 스키마 설계 패턴을 적용합니다. 새 컬렉션 추가, 관계 설계, 인덱스 최적화, 데이터 마이그레이션 시 사용하세요. NoSQL 특성에 맞는 비정규화 전략을 포함합니다.

jhlee0409
jhlee0409
databases
open
sql-databases
0

designing-databases

データベーススキーマ設計と最適化を支援します。正規化戦略、インデックス設計、パフォーマンス最適化を提供します。データモデル設計、データベース構造の最適化が必要な場合に使用してください。

sekka
sekka
databases
open
sql-databases
0

devops-database

Manages PostgreSQL database operations including Alembic migrations (creation, application, rollback), database backups and restoration for both development and production environments, shell access, and pgvector extension management. This skill should be used when creating schema changes, running migrations, backing up data, or troubleshooting database issues.

shredbx
shredbx
databases
open
sql-databases
0

create-query

Generates a Query class for read-only operations. Use when implementing complex data retrieval, reports, or optimized fetching (e.g., "Create a query to list students with GPA").

hieupvXmasEve
hieupvXmasEve
databases
open
sql-databases
0

async-sqlalchemy-patterns

Async SQLAlchemy 2.0+ database patterns for FastAPI including session management, connection pooling, Alembic migrations, relationship loading strategies, and query optimization. Use when implementing database models, configuring async sessions, setting up migrations, optimizing queries, managing relationships, or when user mentions SQLAlchemy, async database, ORM, Alembic, database performance, or connection pooling.

vanman2024
vanman2024
databases
open
sql-databases
0

symfony-skapi-entity-relation

Add a relation between two existing entities. Use when linking entities with ManyToOne, OneToMany, or ManyToMany relationships.

Swoking
Swoking
databases
open
sql-databases
0

op-db-user

查询租户和组织信息(v3_user数据库)。使用 exec_sql 工具执行查询。

SeSiTing
SeSiTing
databases
open
sql-databases
0

postgres-expert

Expert PostgreSQL database administrator specializing in query optimization, indexing strategies, and advanced SQL patterns. Masters replication, partitioning, and performance tuning for mission-critical database systems.

vx-daniel
vx-daniel
databases
open
sql-databases
0

sqlmodel-expert

Advanced SQLModel patterns and comprehensive database migrations with Alembic. Use when creating SQLModel models, defining relationships (one-to-many, many-to-many, self-referential), setting up database migrations, optimizing queries, solving N+1 problems, implementing inheritance patterns, working with composite keys, creating indexes, performing data migrations, or troubleshooting Alembic issues. Triggers include "SQLModel", "Alembic migration", "database model", "relationship", "foreign key", "migration", "N+1 query", "query optimization", "database schema", or questions about ORM patterns.

bilalmk
bilalmk
databases
open
sql-databases
0

db-openapi

查询集成连接器和API配置(v3_openapi数据库)。使用 exec_sql 工具执行查询。

SeSiTing
SeSiTing
databases
open
sql-databases
0

migration-helper

データベースマイグレーションを作成する際に使用。Atlas CLI使用、master/shardingのマイグレーション、SQLite構文。DB変更、テーブル追加、カラム追加、マイグレーションファイル作成時に使用。

taku-o
taku-o
databases
open
sql-databases
0

supabase

Supabase open-source Firebase alternative with PostgreSQL database, authentication, storage, real-time subscriptions, and edge functions

git-tao
git-tao
databases
open
sql-databases
0

postgresql-16

PostgreSQL 16 database documentation. Use for SQL queries, indexes, transactions, JSON operations, full-text search, and performance tuning.

Genius-Cai
Genius-Cai
databases
open
sql-databases
0

activerecord-patterns

This skill should be used when the user asks about "ActiveRecord", "database queries", "query optimization", "N+1 queries", "eager loading", "associations", "migrations", "database indexes", "SQL performance", "ActiveRecord callbacks", "scopes", or needs guidance on efficient database access patterns in Rails 7+.

betamatt
betamatt
databases
open
sql-databases
0

drizzle-orm

Drizzle ORM patterns for Neon PostgreSQL. Use when creating tables, schemas, migrations, or database queries.

tirtza-weinfeld
tirtza-weinfeld
databases
open
sql-databases
0

memory-recall

Query the worklog database for context, knowledge, errors, and history

gaurangrshah
gaurangrshah
databases
open
sql-databases
0

elixir-ecto

Ecto schemas, changesets, queries, migrations, and database patterns for Elixir applications

vircung
vircung
databases
open
sql-databases
0

persistence-layer-audit

Audit SQLite persistence layer for unused tables and broken integrations. Trigger when: (1) checking database usage, (2) cleaning up schema, (3) finding missing methods.

smith6jt-cop
smith6jt-cop
databases
open
sql-databases
0

sqlite

SQLite problem-solving patterns for embedded/edge deployments. Use when: connection setup, "database locked" errors, ALTER TABLE workarounds, concurrency problems, FTS setup, SQLite-specific gotchas. Do not use for: basic DDL/DML syntax (use context7 MCP), schema design decisions (use data-modeling skill first). Workflow: data-modeling skill (design) → this skill (implement). Decision: If asking "should I use PostgreSQL instead?" — see comparison section at bottom.

zzoohub
zzoohub
databases
open
sql-databases
0

persistence-expert

Long FK 전략, QueryDSL DTO Projection, N+1 해결. JPA 관계 어노테이션 금지. /kb-persistence 명령 시 자동 활성화.

ryu-qqq
ryu-qqq
databases
open
sql-databases
0

sql-optimization-patterns

SQL 쿼리 최적화, 인덱스 전략 및 EXPLAIN 분석을 마스터하여 데이터베이스 성능을 획기적으로 향상시키고 느린 쿼리를 제거합니다. 느린 쿼리 디버깅, 데이터베이스 스키마 설계 또는 애플리케이션 성능 최적화 시 사용하세요.

icartsh
icartsh
databases
open
sql-databases
0

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 data layers.

martinffx
martinffx
databases
open
sql-databases
0

postgres-schema-design

Comprehensive PostgreSQL-specific table design reference covering data types, indexing, constraints, performance patterns, and advanced features. Use when designing database schemas, creating tables, or reviewing database structure.

francanete
francanete
databases
open
sql-databases
0

project-memory

Armazena e consulta memória persistente de projetos em banco PostgreSQL. Use quando: (1) tomar decisões técnicas importantes, (2) identificar TODOs/melhorias, (3) documentar contexto do projeto, (4) consultar decisões anteriores. O Claude deve AUTOMATICAMENTE salvar decisões importantes e consultar memória relevante. Identificação do projeto é automática via git repo + branch.

sioux1to1
sioux1to1
databases
open
Previous
Page 75 / 81
Next