GitHub
drizzle-orm
DrizzleORMを使用したデータベーススキーマ設計、マイグレーション、型安全なクエリ構築を専門とするスキル。 SQLite、PostgreSQL、MySQLに対応し、TypeScriptの型システムを最大限活用した堅牢なDB層を構築する。 Anchors: •...
☆ 5View skill
research sql databases AI Skills
Discover research sql databases skills, compare source repositories and read the instructions for each workflow.
Categories: research sql databases
research sql databases Clear filters
Browse skills
GitHub
foreign-key-constraints
外部キー制約と参照整合性をC.J. Dateの理論に基づいて設計するスキル。CASCADE動作の戦略的選択、循環参照の検出・解消、ソフトデリート整合性を提供。SQLite/Turso + Drizzle ORM環境に最適化。 Anchors: • An Introduction...
☆ 5View skill
GitHub
connection-pooling
データベース接続プール設計と運用を支援するスキル。 サーバーレス環境やTursoの接続制約を踏まえたサイジングと検証手順を整理する。 Anchors: • 『The Pragmatic Programmer』（Andrew Hunt, David Thomas）/ 適用: 実践的...
☆ 5View skill
GitHub
database-monitoring
データベース監視の設計・実装・検証を体系化するスキル。 SQLite/Tursoの統計情報、スロークエリ、接続数、ストレージを含めた監視運用を整理する。 Anchors: • Designing Data-Intensive Applications / 適用: 性能とスケー...
☆ 5View skill
GitHub
database-schema-designer
Design PostgreSQL, MongoDB, or Redis schemas with entities, relationships, indexes, constraints, migrations, query optimization, and backward-compatible schema evolution
☆ 5View skill
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...
☆ 5View skill
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...
☆ 5View skill
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...
☆ 5View skill
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...
☆ 5View skill
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...
☆ 5View skill
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...
☆ 5View skill
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...
☆ 5View skill
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...
☆ 5View skill
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...
☆ 5View skill
GitHub
database-model
Create Prisma schema models with relations and indexes. Use when designing database schemas, adding models, or defining entity relationships.
☆ 5View skill
GitHub
effect-sql-db
Effect patterns for SQL databases (Drizzle/Kysely/Prisma): services, transactions, retries, streaming, and observability.
☆ 5View skill
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...
☆ 5View skill
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...
☆ 5View skill
GitHub
sql-optimization-patterns
SQLクエリ最適化、インデックス戦略、EXPLAIN分析をマスターし、データベースパフォーマンスを劇的に向上させ、遅いクエリを排除。遅いクエリのデバッグ、データベーススキーマの設計、アプリケーションパフォーマンスの最適化...
☆ 5View skill
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.
☆ 5View skill
GitHub
sql
Read when writing raw SQL queries
☆ 5View skill
GitHub
prisma
Read when modifying schema.prisma
☆ 5View skill
GitHub
execute-sql
To read the DB, use mcp-postgres MCP tools
☆ 5View skill
GitHub
agentuity-cli-cloud-db-sql
Execute SQL query on a database. Requires authentication. Use for Agentuity cloud platform operations
☆ 4View skill
The default order uses GitHub repository stars from our indexed data. Stars belong to the source repository and may be shared by multiple skills. They indicate repository interest, not skill installs or an independent quality score.