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 and secure database queries using parameterized queries, eager loading to prevent N+1 problems, selective column fetching, strategic indexing, transactions for related changes, query timeouts, and caching for expensive queries. Use this skill when writing Eloquent queries or raw SQL, optimizing database performance, preventing N+1 query problems with eager loading, implementing database transactions, adding indexes to improve query speed, or caching frequently-run queries. This skill applies when working with Eloquent query builder, raw database queries, query optimization, or any code that interacts with the database.

FlorianRiquelme

databases

sql-databases

0

neo4j-patterns

Neo4j driver best practices for Python. Use when working with Neo4j connections, Cypher queries, transactions, or GraphRAG implementations.

arthurfantaci

databases

sql-databases

0

database-query-optimizer

Analyze and optimize Django ORM queries including N+1 problems, missing indexes, slow queries, and migration issues. Use when troubleshooting slow API responses, database performance, query optimization, or migration errors.

allthriveai

databases

sql-databases

0

sharding-pattern

シャーディング対応のコードを書く際に使用。user_idベースのhash sharding、テーブル分割、クロスシャードクエリ、Repository実装時に自動適用。シャーディング、分散DB、テーブル分割、クロスDBクエリを扱う場合に使用。

taku-o

databases

sql-databases

0

databases

RDBMS access patterns for DuckDB, MySQL (keycloak), PostgreSQL (dw, x3rocs), SQL Server (sage1000, x3), and DBISAM (Exportmaster) using ODBC and native drivers

lawless-m

databases

sql-databases

0

agentuity-cli-cloud-db-sql

Execute SQL query on a database. Requires authentication. Use for Agentuity cloud platform operations

agentuity

databases

sql-databases

0

query-supabase-database

Execute PostgreSQL queries against the Supabase database using psql with 1Password credential retrieval

bigandslow

databases

sql-databases

0

model-queries

Building database queries with the Options API. Use when you need to query a model by creating a new query or updating an existing one

griffnb

databases

sql-databases

0

op-db-openapi

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

SeSiTing

databases

sql-databases

0

sqlmodel-orm-dbhelper

Design and implement production-grade database layers using SQLModel with SQLAlchemy 2.0 patterns. This skill should be used when users need to create database models, configure engines/sessions, design schemas, implement relationships, or optimize database performance in Python FastAPI projects.

alijilani-dev

databases

sql-databases

0

sqlite-database-expert

Expert in SQLite embedded database development for Tauri/desktop applications with focus on SQL injection prevention, migrations, FTS search, and secure data handling

runecalico-ai

databases

sql-databases

0

writing-convex-functions

Creates Convex queries, mutations, or actions for database operations. Input: Function type (query/mutation/action), table, and operation. Output: Typed Convex function with args validation.

Simplereally

databases

sql-databases

0

database-query-optimization

Comprehensive guide to optimizing database queries, understanding EXPLAIN plans, indexing strategies, and eliminating N+1 queries

AmnadTaowsoam

databases

sql-databases

0

postgresql

PostgreSQL 14+ database design, Flyway migrations, and JPA queries for the casino platform. Use when: Creating or modifying database tables, writing migrations, designing entities, writing repository queries, or troubleshooting data layer issues.

psh-inc

databases

sql-databases

0

backend-models

Define database models and ORM classes with proper data types, relationships, constraints, and validation logic following framework conventions. Use this skill when working with model definitions, schema classes, entity files, or database table representations in files like models.py, entities.ts, schema.prisma, or models/. Applies when defining table structures, relationships (one-to-many, many-to-many), validation rules, timestamps, indexes, foreign keys, and data integrity constraints at the database level.

grimmolf

databases

sql-databases

0

supabase-rls

Supabase Row Level Security policies. Use when creating RLS policies, securing tables, or implementing multi-tenant data isolation.

dvorkinguy

databases

sql-databases

0

write-sql

Write and execute SQL queries against the database with query optimization, validation, and dialect-aware syntax

srsubramanian

databases

sql-databases

0

sql-db-architecture

Understand the toy relational database architecture, crate organization, data flow, and implementation patterns. Use when exploring the database codebase, understanding query execution, debugging storage/indexing, or planning new features. Keywords: sql-database, database, crate, storage, executor, planner, parser, catalog, WAL, buffer pool, index, architecture

wcygan

databases

sql-databases

0

cassandra-expert

Expert Apache Cassandra database administrator specializing in data modeling, replication strategies, and performance optimization. Masters CQL queries, cluster management, and scaling Cassandra for high-availability deployments.

vx-daniel

databases

sql-databases

0

sequelize-models

Sequelize ORM model definition patterns and best practices for PostgreSQL. Use when defining models, setting up associations, configuring validations, or optimizing Sequelize usage.

francanete

databases

sql-databases

0

databases

RDBMS access patterns for DuckDB, MySQL (keycloak), PostgreSQL (dw, x3rocs), SQL Server (sage1000, x3), and DBISAM (Exportmaster) using ODBC and native drivers

lawless-m

databases

sql-databases

0

db-e-report

提供v3_e-report数据库的SQL查询模板，包括数据分析告警配置等表的查询。查询分析告警配置时使用。使用 exec_sql 工具执行查询。

SeSiTing

databases

sql-databases

0

database-operations

A skill for performing database CRUD operations following best practices. Includes guidance on session management, query building (filters, joins, aggregations), transaction handling, bulk operations, error handling, connection pooling, and query optimization. Provides reusable templates for database session dependencies, CRUD service classes, and transaction context managers.

MUmerRazzaq

databases

sql-databases

0

drizzle-db

Query the project's database using Drizzle ORM. Use when the user asks about database contents, schema inspection, or data queries. Supports read-only mode for safety.

Fawwaz-2009

databases

Page 72 / 81