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
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
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
GitHub
sql-query-optimizer
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...
☆ 10View skill
GitHub
data-integrity-auditor
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...
☆ 10View skill
GitHub
frappe-performance-optimizer
Generate optimized queries, caching, and indexes for Frappe performance. Use when optimizing slow queries, implementing caching, or improving performance.
☆ 10View skill
GitHub
doris-mysql
通过指定 host/port 直连 Doris FE 并执行 SQL；用于已知连接地址时查询或执行 SQL。
☆ 10View skill
GitHub
multi-agent-e2e-validation
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...
☆ 9View skill
GitHub
test-json-sql-pluck
Tests pluck primitive (SELECT single field)
☆ 9View skill
GitHub
test-json-sql-search-web
Test JSON SQL primitives with search-web output
☆ 9View skill
GitHub
test-json-sql-filter
Tests filter-structured primitive (WHERE clause)
☆ 9View skill
GitHub
filter-structured
Filter Collection by field conditions (SQL WHERE)
☆ 9View skill
GitHub
test-json-sql-sort
Tests sort primitive (ORDER BY)
☆ 9View 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.