GitHub
database
Work with the SQLite database layer including FTS5, sqlite-vec, and schema operations. Use for database queries, indexing issues, or storage debugging.
☆ 0查看技能
blockchain sql databases AI 技能
发现 blockchain sql databases 相关 Skills，比较来源仓库和用途，查看适合你工作流的技能说明。
分类目录: blockchain sql databases
blockchain sql databases 清除筛选
全部技能
GitHub
database-schema
Use when working with database models or migrations. Contains schema documentation and relationship patterns.
☆ 0查看技能
GitHub
sql-patterns
SQL query patterns, optimization, and database best practices. Use when writing SQL queries, discussing database design, query optimization, or working with PostgreSQL, MySQL, SQLite. Triggers on mentions of SQ...
☆ 0查看技能
GitHub
supabase-schema-validator
Validates Supabase database schema changes for the NABIP AMS, ensuring migrations align with member management, event tracking, chapter hierarchy, and financial models. Use when working with Supabase tables, RL...
☆ 0查看技能
GitHub
postgresql-16
PostgreSQL 16 database documentation. Use for SQL queries, indexes, transactions, JSON operations, full-text search, and performance tuning.
☆ 0查看技能
GitHub
backend-queries
Write secure, performant, and optimized database queries using parameterized queries, eager loading, proper indexing, and transaction management. Use this skill when writing database queries in controllers, rep...
☆ 0查看技能
GitHub
backend-models
Define and configure database models with proper naming, relationships, timestamps, data types, constraints, and validation. Use this skill when creating or editing model files in app/Models/, Eloquent model cl...
☆ 0查看技能
GitHub
backend-migrations
Create reversible, focused database migrations with proper naming, version control practices, and zero-downtime deployment considerations. Use this skill when creating or editing migration files in database/mig...
☆ 0查看技能
GitHub
backend-queries
Write efficient, secure database queries using ORMs or raw SQL, preventing N+1 problems, SQL injection, and performance issues. Use this skill when writing database queries, implementing data access layers, cre...
☆ 0查看技能
GitHub
backend-models
Define database models, schemas, and ORM mappings with proper relationships, constraints, and data integrity rules. Use this skill when creating or modifying ORM model classes, database schema definitions, mode...
☆ 0查看技能
GitHub
postgres-query-optimization
PostgreSQL query optimization and performance tuning reference. Use when analyzing slow queries, interpreting EXPLAIN output, optimizing indexes, or troubleshooting database performance issues.
☆ 0查看技能
GitHub
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.
☆ 0查看技能
GitHub
sequelize-migrations
Sequelize migration patterns and best practices for PostgreSQL schema changes. Use when creating migrations, modifying tables, managing indexes, or handling data migrations safely.
☆ 0查看技能
GitHub
postgres-schema-design
Comprehensive PostgreSQL-specific table design reference covering data types, indexing, constraints, performance patterns, and advanced features. Use when designing database schemas, creating tables, or reviewi...
☆ 0查看技能
GitHub
supabase-migration
Safe database migration creation and management for Supabase PostgreSQL
☆ 0查看技能
GitHub
food-journal-database
Describes the structure of the Food Journal database that allows to store and read food journal entries
☆ 0查看技能
GitHub
database
Database schemas, table specifications, and migration information. Use when working with database structure or queries.
☆ 0查看技能
GitHub
data-quality-test-generator
Generate comprehensive dbt test suites following FF Analytics data quality standards and dbt 1.10+ syntax. This skill should be used when creating tests for new dbt models, adding tests to existing models, stan...
☆ 0查看技能
GitHub
optimizing-query-performance
Optimize queries with indexes, batching, and efficient Prisma operations for production performance.
☆ 0查看技能
GitHub
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.
☆ 0查看技能
GitHub
preventing-sql-injection
Prevent SQL injection by using $queryRaw tagged templates instead of $queryRawUnsafe. Use when writing raw SQL queries or dynamic queries.
☆ 0查看技能
GitHub
upgrading-to-prisma-6
Migrate from Prisma 5 to Prisma 6 handling breaking changes including Buffer to Uint8Array, implicit m-n PK changes, NotFoundError to P2025, and reserved keywords. Use when upgrading Prisma, encountering Prisma...
☆ 0查看技能
GitHub
using-interactive-transactions
Use interactive transactions with $transaction callback for atomic operations and automatic rollback. Use when operations must succeed or fail together.
☆ 0查看技能
GitHub
implementing-query-pagination
Implement cursor-based or offset pagination for Prisma queries. Use for datasets 100k+, APIs with page navigation, or infinite scroll/pagination mentions.
☆ 0查看技能
默认按已收录数据中的 GitHub 仓库 Stars 排序。Stars 属于来源仓库，同一仓库的多个技能可能共享相同数值；它反映仓库关注度，不代表单个技能的安装量或质量评分。