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.
☆ 12Voir le skill
Skills IA research sql databases
Découvrez les skills research sql databases, comparez leurs dépôts et consultez leurs instructions.
Catégories: research sql databases
research sql databases Effacer les filtres
Explorer
GitHub
database-advanced-optimization
Use SQL (PostgreSQL) when:
☆ 12Voir le 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...
☆ 11Voir le 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
☆ 11Voir le 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.
☆ 11Voir le 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,...
☆ 11Voir le 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.
☆ 11Voir le 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...
☆ 11Voir le 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...
☆ 11Voir le 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...
☆ 11Voir le 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.
☆ 10Voir le skill
GitHub
prisma-query-optimizer
Query optimization and N+1 detection
☆ 10Voir le 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...
☆ 10Voir le 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...
☆ 10Voir le 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...
☆ 10Voir le 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...
☆ 10Voir le skill
GitHub
frappe-performance-optimizer
Generate optimized queries, caching, and indexes for Frappe performance. Use when optimizing slow queries, implementing caching, or improving performance.
☆ 10Voir le skill
GitHub
doris-mysql
通过指定 host/port 直连 Doris FE 并执行 SQL；用于已知连接地址时查询或执行 SQL。
☆ 10Voir le 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...
GitHub
test-json-sql-pluck
Tests pluck primitive (SELECT single field)
GitHub
test-json-sql-search-web
Test JSON SQL primitives with search-web output
GitHub
test-json-sql-filter
Tests filter-structured primitive (WHERE clause)
GitHub
filter-structured
Filter Collection by field conditions (SQL WHERE)
GitHub
test-json-sql-sort
Tests sort primitive (ORDER BY)
Le classement utilise les étoiles du dépôt GitHub indexé. Plusieurs skills peuvent partager ce nombre : ce n’est ni un nombre d’installations ni une note de qualité.