GitHub
kysely
Kysely type-safe SQL query builder - End-to-end type safety from schema to queries, migrations, transactions, plugins
☆ 12View skill
blockchain sql databases AI Skills
Discover blockchain sql databases skills, compare source repositories and read the instructions for each workflow.
Categories: blockchain sql databases
blockchain sql databases Clear filters
Browse skills
GitHub
database-migration
Safe patterns for evolving database schemas in production with decision trees and troubleshooting guidance.
☆ 12View skill
GitHub
golang-database-patterns
Go database integration patterns using sqlx, pgx, and migration tools like golang-migrate
☆ 12View skill
GitHub
database-schema-design
Design and optimize database schemas for SQL and NoSQL databases. Use when creating new databases, designing tables, defining relationships, indexing strategies, or database migrations. Handles PostgreSQL, MySQ...
☆ 12View skill
GitHub
hive
TD Hive SQL with TD-specific functions and Hive-only features (lateral view, explode, MAPJOIN hint). Use when Trino memory errors occur or for Hive-specific syntax.
☆ 12View skill
GitHub
aps-doc-staging
Expert documentation generation for staging transformation layers. Auto-detects SQL engine (Presto/Trino vs Hive), documents transformation rules, PII handling, deduplication strategies, and data quality rules....
☆ 12View skill
GitHub
aps-doc-hist-union
Expert documentation generation for hist-union workflows. Documents historical and incremental table combination strategies, schema validation, time-based partitioning, and backfill processes. Use when document...
☆ 12View skill
GitHub
trino-to-hive-migration
Convert Trino queries to Hive when memory errors occur. Covers syntax differences (td_time_string→TD_TIME_FORMAT, REGEXP_LIKE→RLIKE, ARRAY_AGG→COLLECT_LIST) and engine selection.
☆ 12View skill
GitHub
trino
TD Trino SQL with TD-specific functions (td_interval, td_time_range, td_time_string, td_sessionize). Use for time-based filtering, partition pruning, and TD query patterns.
☆ 12View skill
GitHub
trino-optimizer
TD Trino performance optimization including CTAS (5x faster), UDP bucketing for ID lookups, magic comments for join distribution, REGEXP_LIKE vs LIKE, and approx functions.
☆ 12View skill
GitHub
dbt
dbt with TD Trino. Covers profiles.yml setup (method:none, user:TD_API_KEY), required override macros (no CREATE VIEW), TD_INTERVAL in models, and TD Workflow deployment.
☆ 12View skill
GitHub
database-advanced-optimization
Use SQL (PostgreSQL) when:
☆ 12View skill
GitHub
databases
MongoDB and PostgreSQL database administration. Databases: MongoDB (document store, aggregation, Atlas), PostgreSQL (relational, SQL, psql). Capabilities: schema design, query optimization, indexing, migrations...
☆ 11View skill
GitHub
prisma-orm-v7-skills
Key facts and breaking changes for upgrading to Prisma ORM 7. Consider version 7 changes before generation or troubleshooting
☆ 11View skill
GitHub
init-postgres-mac
Install, configure, and manage PostgreSQL server with pgvector extension on macOS using Homebrew. Supports init, start, stop, restart, status, and remove operations.
☆ 11View skill
GitHub
clone-database
Clone MySQL/PostgreSQL databases from remote servers to local machine. Use when user mentions cloning database from EC2/server to local, copying remote database, or pulling database from remote. Handles backup,...
☆ 11View skill
GitHub
sql-cli
Token-efficient MySQL/PostgreSQL operations using mycli and native CLI tools (Windows/Mac/Linux compatible). Replaces Artisan Tinker for database queries with 87% token savings.
☆ 11View skill
GitHub
database
Query and analyze the Gertrude PostgreSQL database. Use when answering questions about database schema, writing SQL queries, analyzing data, or debugging database-related issues. Has read-only access via the 'r...
☆ 11View skill
GitHub
linq-optimization-patterns
Master LINQ and EF Core query optimization including N+1 prevention, eager loading, projections, and performance patterns. Use when: (1) fixing N+1 queries, (2) optimizing slow queries, (3) implementing efficie...
☆ 11View skill
GitHub
database-architect
Expert database schema designer and Drizzle ORM specialist. Use when user needs database design, schema creation, migrations, query optimization, or Postgres-specific features. Examples - "design a database sch...
☆ 11View skill
GitHub
database-design
Database schema design, migrations, query optimization, and ORM patterns. Use when designing database schemas, writing migrations, optimizing queries, or working with ORMs like SQLAlchemy or Django ORM.
☆ 10View skill
GitHub
prisma-query-optimizer
Query optimization and N+1 detection
☆ 10View skill
GitHub
schema-consistency-checker
Audits database schemas for naming conventions, type consistency, nullability patterns, and missing constraints. Provides violations report with recommended fixes. Use for "schema validation", "database linting...
☆ 10View skill
GitHub
prisma-migration-assistant
Plans and executes safe Prisma schema migrations with data backfills, rollback strategies, and SQL preview. Handles complex schema changes including data transformations. Use for "Prisma migrations", "schema ch...
☆ 10View 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.