research sql databases AI 技能

发现 research sql databases 相关 Skills，比较来源仓库和用途，查看适合你工作流的技能说明。

分类目录: research sql databases

research sql databases 清除筛选

GitHub

dbt

treasure-data

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

williamzujkowski

Use SQL (PostgreSQL) when:

☆ 12查看技能

GitHub

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

gocallum

Key facts and breaking changes for upgrading to Prisma ORM 7. Consider version 7 changes before generation or troubleshooting

☆ 11查看技能

GitHub

init-postgres-mac

yanmxa

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

yanmxa

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

Interstellar-code

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

gertrude-app

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

thapaliyabikendra

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

marcioaltoe

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

akaszubski

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

databayt

Query optimization and N+1 detection

☆ 10查看技能

GitHub

schema-consistency-checker

patricio0312rev

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

patricio0312rev

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

sql-query-optimizer

patricio0312rev

Analyzes and optimizes SQL queries using EXPLAIN plans, index recommendations, query rewrites, and performance benchmarking. Use for "query optimization", "slow queries", "database performance", or "EXPLAIN ana...

☆ 10查看技能

GitHub

data-integrity-auditor

patricio0312rev

Detects data integrity issues including orphaned records, broken foreign key relationships, constraint violations, and provides automated fix migrations. Use for "data integrity", "orphaned records", "broken re...

☆ 10查看技能

GitHub

frappe-performance-optimizer

Venkateshvenki404224

Generate optimized queries, caching, and indexes for Frappe performance. Use when optimizing slow queries, implementing caching, or improving performance.

☆ 10查看技能

GitHub

doris-mysql

cosven

通过指定 host/port 直连 Doris FE 并执行 SQL；用于已知连接地址时查询或执行 SQL。

☆ 10查看技能

GitHub

multi-agent-e2e-validation

terrylica

Multi-agent parallel E2E validation workflow for database refactors and system migrations. Use when validating QuestDB deployments, schema migrations, bulk data ingestion pipelines, or any database-centric refa...

☆ 9查看技能

GitHub