GitHub
foreign-key-constraints
外部キー制約と参照整合性をC.J. Dateの理論に基づいて設計するスキル。CASCADE動作の戦略的選択、循環参照の検出・解消、ソフトデリート整合性を提供。SQLite/Turso + Drizzle ORM環境に最適化。 Anchors: • An Introduction...
☆ 5查看技能
tools sql databases AI 技能
发现 tools sql databases 相关 Skills，比较来源仓库和用途，查看适合你工作流的技能说明。
分类目录: tools sql databases
tools sql databases 清除筛选
全部技能
GitHub
connection-pooling
データベース接続プール設計と運用を支援するスキル。 サーバーレス環境やTursoの接続制約を踏まえたサイジングと検証手順を整理する。 Anchors: • 『The Pragmatic Programmer』（Andrew Hunt, David Thomas）/ 適用: 実践的...
☆ 5查看技能
GitHub
database-monitoring
データベース監視の設計・実装・検証を体系化するスキル。 SQLite/Tursoの統計情報、スロークエリ、接続数、ストレージを含めた監視運用を整理する。 Anchors: • Designing Data-Intensive Applications / 適用: 性能とスケー...
☆ 5查看技能
GitHub
database-schema-designer
Design PostgreSQL, MongoDB, or Redis schemas with entities, relationships, indexes, constraints, migrations, query optimization, and backward-compatible schema evolution
☆ 5查看技能
GitHub
repository
Go repository implementation with SQLC integration following hexagonal architecture. Use when implementing data persistence layer, creating repository interfaces, or working with SQLC-generated queries. Focuses...
☆ 5查看技能
GitHub
timescaledb
MANDATORY when working with time-series data, hypertables, continuous aggregates, or compression - enforces TimescaleDB 2.24.0 best practices including lightning-fast recompression, UUIDv7 continuous aggregates...
☆ 5查看技能
GitHub
database-architecture
MANDATORY when designing schemas, writing migrations, creating indexes, or making architectural database decisions - enforces PostgreSQL 18 best practices including AIO, UUIDv7, temporal constraints, and modern...
☆ 5查看技能
GitHub
postgis
MANDATORY when working with geographic data, spatial queries, geometry operations, or location-based features - enforces PostGIS 3.6.1 best practices including ST_CoverageClean, SFCGAL 3D functions, and bigint...
☆ 5查看技能
GitHub
activerecord-query-patterns
Complete guide to ActiveRecord query optimization, associations, scopes, and PostgreSQL-specific patterns. Use this skill when writing database queries, designing model associations, creating migrations, optimi...
☆ 5查看技能
GitHub
activerecord-query-patterns
Complete guide to ActiveRecord query optimization, associations, scopes, and PostgreSQL-specific patterns. Use this skill when writing database queries, designing model associations, creating migrations, optimi...
☆ 5查看技能
GitHub
timescaledb
MANDATORY when working with time-series data, hypertables, continuous aggregates, or compression - enforces TimescaleDB 2.24.0 best practices including lightning-fast recompression, UUIDv7 continuous aggregates...
☆ 5查看技能
GitHub
postgis
MANDATORY when working with geographic data, spatial queries, geometry operations, or location-based features - enforces PostGIS 3.6.1 best practices including ST_CoverageClean, SFCGAL 3D functions, and bigint...
☆ 5查看技能
GitHub
database-architecture
MANDATORY when designing schemas, writing migrations, creating indexes, or making architectural database decisions - enforces PostgreSQL 18 best practices including AIO, UUIDv7, temporal constraints, and modern...
☆ 5查看技能
GitHub
database-model
Create Prisma schema models with relations and indexes. Use when designing database schemas, adding models, or defining entity relationships.
☆ 5查看技能
GitHub
effect-sql-db
Effect patterns for SQL databases (Drizzle/Kysely/Prisma): services, transactions, retries, streaming, and observability.
☆ 5查看技能
GitHub
drizzle-orm
Expert guidance for Drizzle ORM including schema definition, queries, relations, migrations, TypeScript integration with SQLite/PostgreSQL, and Drizzle Studio. Use this when working with type-safe database oper...
☆ 5查看技能
GitHub
sqlite
Expert guidance for SQLite database with better-sqlite3 Node.js driver including database setup, queries, transactions, migrations, performance optimization, and integration with TypeScript. Use this when worki...
☆ 5查看技能
GitHub
sql-optimization-patterns
SQLクエリ最適化、インデックス戦略、EXPLAIN分析をマスターし、データベースパフォーマンスを劇的に向上させ、遅いクエリを排除。遅いクエリのデバッグ、データベーススキーマの設計、アプリケーションパフォーマンスの最適化...
☆ 5查看技能
GitHub
database-patterns
Database design patterns, SQL best practices, ORM usage (Prisma/Drizzle), and migration strategies. Use when designing schemas, writing queries, or optimizing database operations.
☆ 5查看技能
GitHub
agentuity-cli-cloud-db-sql
Execute SQL query on a database. Requires authentication. Use for Agentuity cloud platform operations
☆ 4查看技能
GitHub
agentuity-cli-cloud-db-logs
Get query logs for a specific database. Requires authentication. Use for Agentuity cloud platform operations
☆ 4查看技能
GitHub
agentuity-cli-project-auth-generate
Generate SQL schema for Agentuity Auth tables. Use for managing authentication credentials
☆ 4查看技能
GitHub
agentuity-cli-cloud-db-get
Show details about a specific database. Requires authentication. Use for Agentuity cloud platform operations
☆ 4查看技能
GitHub
drizzle-orm
Drizzle ORM for TypeScript - type-safe SQL queries, schema definitions, migrations, and relations. Use when: building database layers in TypeScript applications.
☆ 4查看技能
默认按已收录数据中的 GitHub 仓库 Stars 排序。Stars 属于来源仓库，同一仓库的多个技能可能共享相同数值；它反映仓库关注度，不代表单个技能的安装量或质量评分。