GitHub
kysely
Kysely type-safe SQL query builder - End-to-end type safety from schema to queries, migrations, transactions, plugins
☆ 12查看技能
devops sql databases AI 技能
发现 devops sql databases 相关 Skills，比较来源仓库和用途，查看适合你工作流的技能说明。
分类目录: devops sql databases
devops sql databases 清除筛选
全部技能
GitHub
database-migration
Safe patterns for evolving database schemas in production with decision trees and troubleshooting guidance.
☆ 12查看技能
GitHub
golang-database-patterns
Go database integration patterns using sqlx, pgx, and migration tools like golang-migrate
☆ 12查看技能
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...
☆ 12查看技能
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.
☆ 12查看技能
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....
☆ 12查看技能
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...
☆ 12查看技能
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.
☆ 12查看技能
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.
☆ 12查看技能
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.
☆ 12查看技能
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.
☆ 12查看技能
GitHub
database-advanced-optimization
Use SQL (PostgreSQL) when:
☆ 12查看技能
GitHub
databases
MongoDB and PostgreSQL database administration. Databases: MongoDB (document store, aggregation, Atlas), PostgreSQL (relational, SQL, psql). Capabilities: schema design, query optimization, indexing, migrations...
☆ 11查看技能
GitHub
prisma-orm-v7-skills
Key facts and breaking changes for upgrading to Prisma ORM 7. Consider version 7 changes before generation or troubleshooting
☆ 11查看技能
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.
☆ 11查看技能
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,...
☆ 11查看技能
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.
☆ 11查看技能
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...
☆ 11查看技能
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...
☆ 11查看技能
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...
☆ 11查看技能
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.
☆ 10查看技能
GitHub
prisma-query-optimizer
Query optimization and N+1 detection
☆ 10查看技能
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...
☆ 10查看技能
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...
☆ 10查看技能
默认按已收录数据中的 GitHub 仓库 Stars 排序。Stars 属于来源仓库，同一仓库的多个技能可能共享相同数值；它反映仓库关注度，不代表单个技能的安装量或质量评分。