GitHub
db-performance-patterns
Patterns for optimizing database queries and preventing connection pool exhaustion. Use when writing batch operations, debugging slow queries, or reviewing code for performance.
☆ 1查看技能
tools sql databases AI 技能
发现 tools sql databases 相关 Skills，比较来源仓库和用途，查看适合你工作流的技能说明。
分类目录: tools sql databases
tools sql databases 清除筛选
全部技能
GitHub
rls-policy-generator
Generate production-ready Row Level Security (RLS) policies for Supabase tables with is_super_admin() bypass, proper USING/WITH CHECK, automated testing framework, performance analysis, and coverage reports. Us...
☆ 1查看技能
GitHub
production-database-query
Query production and staging Supabase databases safely using environment credentials with query approval workflow, safety checker, read-only roles, and audit logging; use when debugging production/staging data,...
☆ 1查看技能
GitHub
db-lint-manager
Lint PostgreSQL functions against schema, analyze usage, and generate fix reports; use when detecting broken functions, validating schema contracts, or cleaning up unused database functions
☆ 1查看技能
GitHub
data-analyst-sql-optimization
Apply SQL optimization patterns including index usage, query rewriting, JOIN optimization, and window functions. Use when improving query performance or analyzing slow queries. This skill provides comprehensiv...
☆ 1查看技能
GitHub
supabase-expert
Comprehensive Supabase expert with access to 2,616 official documentation files covering PostgreSQL database, authentication, real-time subscriptions, storage, edge functions, vector embeddings, and all platfor...
☆ 1查看技能
GitHub
db-explore
Safe database exploration using Laravel Boost tools. Use for querying data, understanding schema, checking records, and debugging data issues. Auto-triggers on "query database", "check data", "find records", "d...
☆ 1查看技能
GitHub
database
Database operation rules (SeaORM, migrations, transaction rules, PostgreSQL). Use when working with database, creating migrations, using SeaORM, asking about DB operations, schema changes, queries, or entity de...
☆ 1查看技能
GitHub
backend-migrations
Create and manage database migrations with reversible changes, zero-downtime deployments, and proper version control practices. Use this skill when creating database migration files, schema change scripts, or a...
☆ 1查看技能
GitHub
backend-queries
Write secure, performant database queries using parameterized queries, eager loading, proper indexing, and transactions. Use this skill when writing database query code, ORM query methods, SQL statements, or da...
☆ 1查看技能
GitHub
postgresql
PostgreSQL DBA skill for schema design review, indexing, query tuning (EXPLAIN/ANALYZE), vacuum/autovacuum, concurrency/locking, partitioning, backup/restore, replication/HA, and safe migrations. Use for tasks...
☆ 1查看技能
GitHub
pg-doc-schema-review
Review and fix PRD/BP/tech design Markdown that includes PostgreSQL table DDL and API examples. Use to enforce these conventions: no auto-increment primary keys, no foreign keys, avoid join-based designs, uniqu...
☆ 1查看技能
GitHub
mysql
MySQL DBA skill for schema design review, indexing, query performance tuning (EXPLAIN), transaction/isolation issues, replication/high availability, backup/restore, and operational checklists. Use for tasks lik...
☆ 1查看技能
GitHub
redis
Redis DBA skill for cache/data-structure design, performance tuning, memory optimization, persistence (RDB/AOF), replication/cluster, high availability (Sentinel), and operational troubleshooting. Use for tasks...
☆ 1查看技能
GitHub
database-patterns
Provides Prisma-specific patterns for soft delete, transactions, optimistic locking, bulk operations, and performance optimization. This skill should be used when implementing data persistence, handling concurr...
☆ 1查看技能
GitHub
repository-pattern
Provides general guidance for implementing data access layers in backend applications. This skill should be used when designing repositories, implementing query methods, or managing database access patterns.
☆ 1查看技能
GitHub
supabase-engineer
Database specialist - handles RLS policies, migrations, type generation, and Supabase integration patterns.
☆ 1查看技能
GitHub
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.
☆ 1查看技能
GitHub
database-operations
PostgreSQL database patterns and Data Gateway compliance
☆ 1查看技能
GitHub
sql-query-helper
Generate, optimize, and explain SQL queries with best practices. Use when writing database queries or optimizing SQL performance.
☆ 1查看技能
GitHub
context-database-schema
Supabase PostgreSQL schema management, 86+ migrations, RLS policies, and type generation. Handles table creation, schema changes, migrations, foreign key constraints, and migration workflows. Use when working w...
☆ 1查看技能
GitHub
gcp-bq-table-management
Use when creating BigQuery tables, implementing partitioning or clustering, managing table schemas, or optimizing table structure. Covers time-based partitioning, range partitioning, clustering strategies, DDL...
☆ 1查看技能
GitHub
bq-query-optimization
Use when writing BigQuery queries, optimizing query performance, analyzing execution plans, or avoiding common SQL gotchas. Covers parameterized queries, UDFs, scripting, window functions (QUALIFY, ROW_NUMBER,...
☆ 1查看技能
GitHub
datomic
How to extract data from a Datomic database for maximum scalability and performance, with particular emphasis on leveraging standard query and indexes to get the best overall multiuser performance with emphasis...
☆ 1查看技能
默认按已收录数据中的 GitHub 仓库 Stars 排序。Stars 属于来源仓库，同一仓库的多个技能可能共享相同数值；它反映仓库关注度，不代表单个技能的安装量或质量评分。