Skills tagged: SQL

• vdb - Guide user to query genomic datasets via labretriever MCP

  vdblabretrieverDuckDBgenomics

  ★ 2 · Updated 2026-09-15

  Orients users and guides effective query workflows for genomic datasets hosted on HuggingFace using labretriever DuckDB SQL MCP tools.

  ⚙ List registered view names⚙ Inspect dataset columns and types⚙ Retrieve column semantic roles
• data-sql - SQL Query Design and Optimization

  SQLdatabasequery optimizationindexing

  ★ 2 · Updated 2026-06-30

  SQL query design, optimization, EXPLAIN analysis, index strategy for relational databases

  ⚙ write SQL queries⚙ analyze EXPLAIN plans⚙ design indexes
• typescript-drizzle-orm - Type-safe SQL ORM with Drizzle

  ORMTypeScriptPostgreSQLMySQL

  ★ 31 · Updated 2026-06-15

  Type-safe ORM for TypeScript defining schemas, queries, relations, and migrations for PostgreSQL, MySQL, SQLite, and Cloudflare D1

  ⚙ define schema⚙ write queries⚙ setup relations
• azure-resource-manager-sql-dotnet - Azure SQL Management with .NET SDK

  AzureSQLresource management.NET

  ★ 1 · Updated 2026-06-15

  Provision and manage Azure SQL resources via Azure Resource Manager

  ⚙ create SQL server⚙ create SQL database⚙ create elastic pool
• dbt-develop - Create and modify dbt models

  dbtSQLdata modelingdata warehouse

  ★ 571 · Updated 2026-05-11

  Create and modify dbt models including staging, intermediate, marts, and incremental materialization with medallion architecture support

  ⚙ create dbt model⚙ modify dbt model⚙ generate YAML config
• database-patterns - Database Design and Access Patterns

  database designschema designrepository patternSQL

  ★ 282 · Updated 2026-05-11

  Design database schemas, implement repository patterns, optimize queries, and manage migrations for SQL/NoSQL databases

  ⚙ design schemas⚙ implement repository pattern⚙ write optimized queries
• h2-database - Connect and query stocks application H2 database

  databaseH2SQLstocks

  ★ 0 · Updated 2026-05-09

  Guide for connecting to and querying the H2 database used by the stocks application

  ⚙ connect to H2 database⚙ run SQL queries⚙ inspect database tables
• db-schema - Design Postgres Database Schemas

  databasepostgressupabaseschema

  ★ 27 · Updated 2026-03-26

  Design a Postgres database schema from product requirements with Supabase awareness

  ⚙ identify entities and relationships⚙ design database tables⚙ define table relationships
• answering-natural-language-questions-with-dbt - Answer Business Questions with dbt

  dbtdata querybusiness intelligencesemantic layer

  ★ 2 · Updated 2026-03-25

  Answer business data questions using semantic layer, SQL modification, model discovery, or manifest analysis

  ⚙ list metrics⚙ get dimensions⚙ query metrics
• answering-natural-language-questions-with-dbt - Query business data using dbt semantic layer

  dbtsemantic layerdata querybusiness intelligence

  ★ 1 · Updated 2026-03-25

  Answer business questions by querying data through semantic layer, SQL modification, model discovery, or manifest analysis

  ⚙ list metrics⚙ get dimensions⚙ query metrics
• answering-natural-language-questions-with-dbt - Answer business data questions with dbt

  Data AnalyticsBusiness IntelligenceData QueryingSemantic Layer

  ★ 0 · Updated 2026-03-25

  Answer business questions using dbt semantic layer and SQL

  ⚙ list metrics⚙ get dimensions⚙ query metrics
• database-schema-designer - Relational Database Schema Design & Migration Tool

  databaseschemamigrationbackend

  ★ 6 · Updated 2026-03-24

  Design relational database schemas and generate migrations, types, and policies

  ⚙ design schemas⚙ generate migrations⚙ generate types
• finance - SmartMES Finance Analytics SQL Generator

  financeSQLbudgetingactual

  ★ 0 · Updated 2026-03-24

  Generates SQL queries for financial data analysis on cost allocation database.

  ⚙ parse user intent⚙ extract keywords⚙ generate SQL query
• sql-pro - Advanced SQL Database Expert

  SQLDatabaseQuery OptimizationPerformance Tuning

  ★ 57 · Updated 2026-03-23

  Expert SQL specialist for cloud databases, query optimization, and modern data architecture

  ⚙ write optimized SQL queries⚙ design database schema⚙ analyze query execution plans
• sql-pro - Expert SQL Database Optimization and Query Specialist

  SQLdatabasequery optimizationdata modeling

  ★ 1 · Updated 2026-03-23

  Optimize SQL queries and design database schemas for cloud-native and hybrid OLTP/OLAP systems

  ⚙ write SQL queries⚙ optimize query performance⚙ design database schemas
• sql-pro - SQL Database Optimization Expert

  databaseSQLperformance optimizationdata warehouse

  ★ 23 · Updated 2026-03-23

  Expert SQL specialist for modern database systems, performance optimization, and advanced analytical techniques

  ⚙ optimize SQL queries⚙ design database schema⚙ create indexes
• local-env - Local Environment Management

  Local EnvironmentSQLDatabasePostgreSQL

  ★ 602 · Updated 2026-03-22

  Manage daily-api local development environment including SQL queries, fake payments, and test data

  ⚙ run SQL query⚙ find postgres container⚙ set organization payment
• using-dbt-for-analytics-engineering - dbt Analytics Engineering

  dbtdata engineeringSQLanalytics

  ★ 0 · Updated 2026-03-22

  Build and modify dbt models, write SQL transformations, create tests, and validate results

  ⚙ build dbt models⚙ modify dbt models⚙ write SQL transformations
• proj-gen - Automated Code Generator

  code generationCRUDSQLAPI

  ★ 42 · Updated 2026-03-22

  Unified code generation entry for SQL, CRUD, API, and enum types

  ⚙ generate SQL table⚙ generate CRUD code⚙ generate API interface
• enrollment-analytics - Analyze student enrollment data with SQL

  analyticsenrollmentSQLstudent

  ★ 14 · Updated 2026-03-22

  Execute SQL queries on student enrollment analytics table to answer student-centric enrollment questions

  ⚙ read metadata files⚙ read sample data⚙ generate SQL queries

Scroll to load more