home/categories/databases
domain cluster

Databases

SQL, NoSQL, and database management tools.

3963 スキルall categories
sorting
stars
current ordering strategy
query
all entries
refine the visible subset
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
TheophilusChinomona
databases
open
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
adaptationio
databases
open
sql-databases
0

sql-query-optimization

A skill for optimizing SQL queries, focusing on PostgreSQL. It provides a checklist for query analysis, guidance on reading EXPLAIN plans, and patterns for common optimization problems like N+1 queries, JOINs, and pagination. Includes templates for benchmarking and recommending indexes. Use this skill when a user wants to improve the performance of a SQL query.

MUmerRazzaq
MUmerRazzaq
databases
open
nosql-databases
0

query-db

Query the database, run a query, look up data, search the database, or check data. Use when the user wants to query the database, run a SQL query, look up data, find data, search for records, check the database, or ask questions about data. Executes queries via CLI commands using natural language. Reads schema context from docs/DB.md. Supports MySQL, PostgreSQL, MongoDB, Elasticsearch, Redis, and BigQuery.

Cloud-Officer
Cloud-Officer
databases
open
sql-databases
0

database-optimizer

Use when user needs database query optimization, performance tuning, index strategies, execution plan analysis, or scalability across PostgreSQL, MySQL, MongoDB, Redis, and other database systems.

404kidwiz
404kidwiz
databases
open
sql-databases
0

dbt-model-writer

Writes, edits, and creates dbt models following best practices. Use when user needs to create new dbt SQL models, update existing models, or convert raw SQL to dbt format. Handles staging, intermediate, and mart models with proper config blocks, CTEs, and documentation.

jwest33
jwest33
databases
open
sql-databases
0

postgres-schema-design

PostgreSQL schema design with SQLModel. Use when designing database schemas, creating ERDs, defining models, planning migrations, or reviewing table structures. Triggers on tasks involving database tables, relationships, indexes, or data modeling for PostgreSQL.

MUmerRazzaq
MUmerRazzaq
databases
open
sql-databases
0

planetscale

Implements PlanetScale serverless MySQL with branching workflows, non-blocking schema changes, and Prisma integration. Use when building apps with PlanetScale, implementing database branching, or needing serverless MySQL.

mgd34msu
mgd34msu
databases
open
sql-databases
0

migestion-prisma

Prisma ORM patterns for MiGestion - multi-tenant queries, migrations, seed. Trigger: When writing Prisma queries, migrations, or schema changes.

eduardbar
eduardbar
databases
open
sql-databases
0

moai-domain-database

Database specialist covering PostgreSQL, MongoDB, Redis, and advanced data patterns for modern applications

zellycloud
zellycloud
databases
open
sql-databases
0

database-migration-patterns

Database schema migration patterns and best practices. Use when creating database migrations, implementing zero-downtime schema changes, version control for databases, or managing data migrations.

mindmorass
mindmorass
databases
open
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.

HermeticOrmus
HermeticOrmus
databases
open
nosql-databases
0

database-patterns

Schema design, migrations, queries, and indexing strategies. Use when designing database schemas, writing migrations, or optimizing queries.

erikpr1994
erikpr1994
databases
open
sql-databases
0

database-migration

Database schema migration patterns for Aurora MySQL including reconciliation migrations, idempotent operations, and MySQL-specific gotchas.

Awannaphasch2016
Awannaphasch2016
databases
open
sql-databases
0

sqlmodel-mastery

Comprehensive SQLModel skill for Python database operations with SQL databases. Use when working with SQLModel for (1) Designing database models and table schemas, (2) Creating relationships between tables (foreign keys, one-to-many, many-to-many), (3) Integrating SQLModel with FastAPI for CRUD APIs, (4) Writing queries with select, where, joins, and filtering, (5) Implementing best practices for session management, migrations, and performance optimization. Covers the multiple model pattern (Base, Table, Create, Public, Update), dependency injection, pagination, error handling, and production-ready patterns.

AbdullahMalik17
AbdullahMalik17
databases
open
nosql-databases
0

analyze-db

Analyze, document, map, or scan the database schema. Use when the user wants to analyze the database, document the database, generate schema docs, map the database, create DB documentation, or inspect the database structure. Generates a docs/DB.md file with complete database schema documentation. Auto-detects language/framework. Supports MySQL, PostgreSQL, MongoDB, Elasticsearch, Redis, and BigQuery.

Cloud-Officer
Cloud-Officer
databases
open
sql-databases
0

sqlmodel

Comprehensive SQLModel development assistance including model creation, relationship handling, database operations, and integration with FastAPI. Use when Claude needs to work with SQLModel projects for: (1) Creating data models with SQLModel, (2) Setting up database connections and sessions, (3) Implementing relationships between models, (4) Performing CRUD operations, (5) Handling advanced features like UUIDs and Decimals, or any other SQLModel database operations.

MalikABK
MalikABK
databases
open
nosql-databases
0

rag-index

Manage RAG (Retrieval-Augmented Generation) indexes. Use for indexing outputs, sessions, or checking RAG statistics.

yui-synth-lab
yui-synth-lab
databases
open
nosql-databases
0

vector-databases

Design vector database ingestion and retrieval pipelines (points + payloads, filtered similarity search, multi-stage hybrid retrieval, index maintenance). Use when building RAG/vector search flows or debugging retrieval quality; triggers: vector database, RAG, embeddings, hybrid search, filtered search, Qdrant, Weaviate, Chroma.

cuba6112
cuba6112
databases
open
nosql-databases
0

qdrant-vectordb

Use when working with Qdrant vector database for semantic search and RAG. Covers collection setup, embedding generation, vector upsert/search, HNSW indexing, filtering, and integration with OpenAI embeddings for textbook content retrieval.

muhammad-anas35
muhammad-anas35
databases
open
nosql-databases
0

postgres-vectors

Use when working with embeddings, semantic similarity, vector search, or the <-> <#> <=> operators. Load for pgvector queries, HNSW index creation, embedding storage, or similarity calculations. Covers distance operators, index strategies, and common pitfalls with 384-dimensional vectors.

discountedcookie
discountedcookie
databases
open
nosql-databases
0

qdrant-patterns

Store and retrieve documents using Qdrant for RAG workflows. Use for persistent memory, research storage, and semantic search.

mindmorass
mindmorass
databases
open
nosql-databases
0

qdrant-manager

Manage Qdrant Cloud collections, including vectorization of textbook chapters and metadata tagging for RAG retrieval. Agent: AIEngineer

FAIQahm
FAIQahm
databases
open
sql-databases
0

pg-memory

PostgreSQL memory system for AI agents. Use when: (1) Storing memories (decisions, learnings, observations, errors) (2) Retrieving context from past sessions (3) Searching memories or sources via full-text search (4) Ingesting external sources (docs, podcasts, blogs, Obsidian notes) (5) Tracking costs, tokens, or command analytics Triggers: "pgm", "remember this", "add to memory", "store memory", "search memories", "ingest source", "pg-memory"

pascalandy
pascalandy
databases
open
Previous
Page 140 / 166
Next