sql-databases
0
db-metadata
提供v3_metadata数据库的SQL查询模板，包括对象编码（object_code）、对象名称、事件、按钮配置、自定义字段、元数据字段、插件中心等表的查询。查询对象编码、对象名称、自定义对象时使用。使用 exec_sql 工具执行查询。
SeSiTing
databases
sorting
stars
current ordering strategy
query
all entries
refine the visible subset
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
databases
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
databases
sql-databases
0
query-optimizer
Static analysis of D1 queries to prevent the
littlebearapps
databases
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
databases
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
databases
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
databases
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
databases
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
databases
sql-databases
0
inspect-table
Shows COMPLETE table structure including columns, types, nullability, defaults, and ALL constraints (CHECK, FK, UNIQUE, ENUM values). CRITICAL - Use this skill BEFORE writing ANY SQL INSERT/UPDATE statements or creating database functions. Use when you need to: (1) Verify actual table/column names because documentation may be outdated, (2) Check valid enum/constraint values to prevent constraint violations, (3) See foreign key requirements to prevent FK errors, (4) Identify NOT NULL columns to prevent null violations, or (5) Understand complete table schema before any database operation
zohar-ui
databases
sql-databases
0
supabase-integration
This skill should be used when the user asks to "configure Supabase with SQLAlchemy", "set up Supabase async engine", "create Supabase models", "handle Supabase authentication with SQLAlchemy", or "integrate Supabase pooling with SQLAlchemy async patterns". It provides complete Supabase integration patterns for SQLAlchemy with async support, authentication, and connection pooling optimizations.
kivo360
databases
sql-databases
0
task-crud-model
Create SQLModel models for Todo tasks. Use for database schema generation.
Jawad-Chaudhary
databases
sql-databases
0
backend-models-standards
Define database models with clear naming, appropriate data types, constraints, relationships, and validation at multiple layers. Use this skill when creating or modifying database model files, ORM classes, schema definitions, or data model relationships. Apply when working with model files (e.g., models.py, models/, ActiveRecord classes, Prisma schema, Sequelize models), defining table structures, setting up foreign keys and relationships, configuring cascade behaviors, implementing model validations, adding timestamps, or working with database constraints (NOT NULL, UNIQUE, foreign keys). Use for any task involving data integrity enforcement, relationship definitions, or model-level data validation.
knopki
databases
sql-databases
0
postgres-neon-connection-and-migrations
Standard patterns for connecting applications to Neon Postgres and managing schema changes via migrations (Alembic / SQLModel / SQLAlchemy), with attention to serverless connection behaviour.
Okashanadeem
databases
sql-databases
0
database-observability
Instrument database queries, connection pools, and detect N+1 queries
nexus-labs-automation
databases
sql-databases
0
backend-queries
Write efficient and secure database queries following best practices for SQL injection prevention, N+1 query optimization, and performance for PostgreSQL (Bun.sql, Prisma, Supabase) and Firestore. Use this skill when writing or modifying database queries, implementing data fetching logic, working with ORMs (Prisma, TypeORM, Entity Framework), using Bun.sql native driver, querying Firestore collections, or implementing caching strategies. Apply when working on service files (services/*.ts, repositories/*.ts, *Service.cs), query builder implementations, data access layers, or any code that fetches or manipulates data. This skill ensures parameterized queries to prevent SQL injection (never interpolate user input), eager loading to prevent N+1 problems, selective column fetching (no SELECT *), strategic indexing on WHERE/JOIN/ORDER BY columns, transactions for related operations, query timeouts for performance, caching expensive queries, prepared statements with Bun.sql for repeated queries, and query-driven mod
TheophilusChinomona
databases
sql-databases
0
asyncpg-detection
This skill should be used when the user asks to "detect asyncpg usage", "find asyncpg patterns", "scan for asyncpg imports", or "identify asyncpg database code in FastAPI projects". It automatically scans Python files to identify asyncpg imports, connection patterns, and query execution methods that need conversion to SQLAlchemy.
kivo360
databases
sql-databases
0
database-expert-advisor
Database design, optimization, and operations expert
ljchg12-hue
databases
sql-databases
0
repository-adapters
Modify database repository adapters using sqlc-generated SQLite queries.
matt-riley
databases
sql-databases
0
data-modeling
Transform business requirements into logical data models. Use when: entity extraction, relationship analysis, normalization decisions, schema design. Do not use for: physical implementation details (use postgresql or sqlite skill after this). Workflow: this skill (design) → postgresql/sqlite skill (implement).
zzoohub
databases
sql-databases
0
rls-templates
Row Level Security policy templates for Supabase - multi-tenant patterns, user isolation, role-based access, and secure-by-default configurations. Use when securing Supabase tables, implementing RLS policies, building multi-tenant AI apps, protecting user data, creating chat/RAG systems, or when user mentions row level security, RLS, Supabase security, tenant isolation, or data access policies.
vanman2024
databases
sql-databases
0
schema-evolution-agent
Manages database schema changes and migrations while maintaining backward compatibility
Unicorn
databases