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 naming, data types, constraints, relationships, and indexing strategies. Use this skill when creating or modifying database models, entity definitions, or schema files. When working on files like models.py, models/*.ts, entities/*.ts, schema.prisma, or ORM model definitions. When defining table structures, setting up foreign key relationships, adding database constraints (NOT NULL, UNIQUE), choosing appropriate data types, or implementing model-level validation.

mshafei721
mshafei721
databases
open
sql-databases
0

sqlalchemy

SQLAlchemy Python SQL toolkit and ORM. Use for database models, queries, sessions, relationships, migrations, async database operations, and working with PostgreSQL, MySQL, SQLite, Oracle, SQL Server.

joneqian
joneqian
databases
open
sql-databases
0

prisma-7

Expert Prisma 7 ORM with Rust-free client, 90% smaller bundles, 3x faster queries, TypedSQL, Omit API, and ESM-first architecture. Use when working with databases, Prisma schemas, queries, migrations, relations, or database optimization.

fusengine
fusengine
databases
open
sql-databases
0

orm-patterns

ORM usage patterns, best practices for Prisma and Drizzle, and when to use ORMs vs raw SQL

Lordsisodia
Lordsisodia
databases
open
sql-databases
0

agentuity-cli-cloud-db-logs

Get query logs for a specific database. Requires authentication. Use for Agentuity cloud platform operations

agentuity
agentuity
databases
open
sql-databases
0

php-symfony-doctrine-fetch-modes

Optimize Doctrine queries with fetch modes, eager loading, lazy loading, and query hints. WHEN: Fixing N+1 queries, configuring eager/lazy loading, using EXTRA_LAZY collections, optimizing query performance, adding fetch joins. WHEN NOT: Batch processing large datasets (use php-symfony-doctrine-batch-processing), migrations (use php-symfony-doctrine-migrations).

LounisBou
LounisBou
databases
open
sql-databases
0

readathon-database-safety

Warn and protect against dangerous database operations on production database in the readathon project

stevensouza
stevensouza
databases
open
sql-databases
0

database-design

数据库设计指南。当用户需要设计数据库 Schema、优化索引、规划表结构、处理数据关系或进行数据库性能优化时使用此技能。

enoch-robinson
enoch-robinson
databases
open
sql-databases
0

mysql

MySQL database client with Docker-based mysql CLI

kubiyabot
kubiyabot
databases
open
sql-databases
0

sqlmodel-task-models

This skill should be used when defining a robust, type-safe, and async-compatible database schema for the Todo application using SQLModel, ensuring compatibility with Better Auth and optimized for PostgreSQL.

SyedaNabila559
SyedaNabila559
databases
open
sql-databases
0

database-management

Handles database schema design, Drizzle ORM queries, and Expo SQLite migrations.

yunuskorkmaz
yunuskorkmaz
databases
open
sql-databases
0

moai-platform-supabase

Supabase specialist covering PostgreSQL 16, pgvector, RLS, real-time subscriptions, and Edge Functions. Use when building full-stack apps with Supabase backend.

zellycloud
zellycloud
databases
open
sql-databases
0

verify-sql

Validates SQL statements before execution using comprehensive dry-run checks to catch syntax errors, schema mismatches, constraint violations (CHECK, NOT NULL, UNIQUE), foreign key violations, data type mismatches, and runtime errors without modifying the database. CRITICAL - Use this skill BEFORE executing any INSERT/UPDATE/DELETE statements. Use when you need to: (1) Verify SQL will execute successfully before running it, (2) Check foreign key references exist to prevent FK violations, (3) Validate constraint values match CHECK/enum requirements, (4) Test stored procedure calls with parameter validation, or (5) Eliminate trial-and-error debugging loops by catching errors before execution

zohar-ui
zohar-ui
databases
open
sql-databases
0

op-db

提供通用的SQL查询方法和数据库查询基础。使用 exec_sql 工具执行查询。

SeSiTing
SeSiTing
databases
open
sql-databases
0

db-metadata

提供v3_metadata数据库的SQL查询模板,包括对象编码(object_code)、对象名称、事件、按钮配置、自定义字段、元数据字段、插件中心等表的查询。查询对象编码、对象名称、自定义对象时使用。使用 exec_sql 工具执行查询。

SeSiTing
SeSiTing
databases
open
sql-databases
0

generate-repository

Generate repository class for SQLite data access with CRUD methods, row mapping, and TypeScript types. Use when creating new database tables or data access layers.

marcd35
marcd35
databases
open
sql-databases
0

sql-batching

Prevent D1 "too many SQL variables" errors when using Drizzle ORM. Use this skill whenever writing database queries with `inArray()`, bulk inserts/updates, or any query with dynamic arrays. Critical for queries where array size is unbounded (user teams, registrations, IDs from prior queries).

wodsmith
wodsmith
databases
open
sql-databases
0

query-optimizer

Static analysis of D1 queries to prevent the

littlebearapps
littlebearapps
databases
open
sql-databases
0

numpy-indexing

Advanced indexing techniques including slicing, fancy indexing, and boolean masks, along with memory implications of views vs. copies. Triggers: indexing, slicing, fancy indexing, boolean mask, np.where, np.ix_.

cuba6112
cuba6112
databases
open
sql-databases
0

sqlalchemy-conversion

This skill should be used when the user asks to "convert asyncpg to SQLAlchemy", "convert database queries", "migrate asyncpg code", "transform asyncpg patterns to SQLAlchemy", or "update FastAPI database layer". It provides systematic conversion of asyncpg code to SQLAlchemy async patterns with proper error handling and transaction management.

kivo360
kivo360
databases
open
sql-databases
0

optimizing-query-selection

Optimize queries by selecting only required fields and avoiding N+1 problems. Use when writing queries with relations or large result sets.

djankies
djankies
databases
open
sql-databases
0

db-common

提供通用的数据库查询工作流程、SQL 模板和结果分析方法。使用 exec_sql 工具执行查询。

SeSiTing
SeSiTing
databases
open
sql-databases
0

sql-security

Enforce SQL security and prepared statement usage in TapScore backend. Use when writing any SQL queries, database operations, or data access code. Prevents SQL injection vulnerabilities and ensures transaction safety.

marcusta
marcusta
databases
open
sql-databases
0

supabase-db

Implements Supabase PostgreSQL database with JavaScript client, Row Level Security, real-time subscriptions, and edge functions. Use when building apps with Supabase, implementing RLS policies, or needing real-time database features.

mgd34msu
mgd34msu
databases
open
Previous
Page 153 / 166
Next