LogoClawIndex
CasesSkillsAbout
LogoClawIndex

ClawIndex

OpenClaw Skills & Use Case Index

ClawIndex is an ecosystem-driven index of OpenClaw skills and real-world use cases.

Index

Skills·
Cases

Meta

About·
Disclaimer·
Email·
GitHub
© 2026 ClawIndex All Rights Reserved.

Skills tagged: sql

Browse skills that share this tag.

  • clickhouse-io - ClickHouse database patterns and query optimization
    clickhousedatabaseanalyticssql

    ★ 0 · Updated 2026-09-22

    Provides patterns for ClickHouse table design, query optimization, data ingestion, materialized views, and performance monitoring.

    ⚙ Design ClickHouse table schemas⚙ Optimize analytical queries⚙ Ingest data in batches
  • demo-only-diagnosing-kapoq-data - Diagnosing Kapoq Data
    kapoqmcpdata-diagnosisclickhouse

    ★ 2 · Updated 2026-09-21

    Investigate e-commerce data questions and anomalies via Kapoq MCP server using a two-phase workflow.

    ⚙ Inspect database schemas and tables⚙ Check table date ranges⚙ Draft structured investigation plans
  • database-schema-designer - Design optimized SQL and NoSQL database schemas
    databaseschema-designsqlnosql

    ★ 0 · Updated 2026-09-21

    Designs database schemas, entity relationship diagrams, and migration scripts for SQL and NoSQL databases.

    ⚙ Design SQL database schemas⚙ Design NoSQL database schemas⚙ Create text ERD diagrams
  • echart-skill - EChart Data Analysis Skill
    echartsduckdbsqldata-analysis

    ★ 43 · Updated 2026-09-20

    Analyzes local data using SQL and DuckDB to generate auditable, offline ECharts dashboards and reports.

    ⚙ Clean and import structured data⚙ Execute audited SQL queries⚙ Validate data quality and contracts
  • sql-pro - Master modern SQL and database performance optimization.
    sqldatabase-optimizationquery-tuningdata-modeling

    ★ 0 · Updated 2026-09-18

    Optimizes SQL queries, designs database schemas, and tunes performance across cloud-native and hybrid database systems.

    ⚙ Write complex SQL queries⚙ Analyze query execution plans⚙ Optimize database query performance
  • databases - MongoDB and PostgreSQL Database Guide
    databasesmongodbpostgresqlsql

    ★ 602 · Updated 2026-09-18

    Provides guidance and tools for working with MongoDB document databases and PostgreSQL relational databases.

    ⚙ Design database schemas⚙ Write database queries⚙ Build aggregation pipelines
  • gccli - GBase 8a database querying via gccli CLI
    gccligbasegbase-8adatabase

    ★ 0 · Updated 2026-09-18

    Queries GBase 8a databases via gccli, including schema inspection, SQL execution, and procedure or function invocation.

    ⚙ Check current database context⚙ Inspect table status and schemas⚙ Execute single or multi-statement SQL
  • write-script-mysql - Write MySQL query scripts for Windmill
    windmillmysqlsqldatabase

    ★ 6 · Updated 2026-09-17

    Provides conventions for writing MySQL query scripts in Windmill, including parameter declarations and S3 integration.

    ⚙ Declare script parameters with placeholders⚙ Parse S3Object parameter via JSON_TABLE⚙ Stream query results to S3
  • prisma-client-api - Prisma Client API reference and query guide
    prismadatabaseormtypescript

    ★ 0 · Updated 2026-09-16

    Provides reference and guidance on Prisma Client model queries, filters, relations, transactions, and client methods.

    ⚙ Execute model CRUD operations⚙ Filter and sort database queries⚙ Query data relations
  • prisma-client-api - Prisma Client API Reference
    prismaprisma-clientdatabaseorm

    ★ 0 · Updated 2026-09-16

    Provides API reference for Prisma Client model queries, filters, operators, relations, transactions, and client methods.

    ⚙ Perform CRUD database operations⚙ Filter and sort query results⚙ Query and write model relations
  • supabase-postgres-best-practices - Supabase Postgres performance optimization guide.
    postgressupabasesqldatabase

    ★ 0 · Updated 2026-09-16

    Provides Postgres performance optimization rules, schema design guidelines, query tuning advice, and Supabase database best practices.

    ⚙ Optimize Postgres SQL queries⚙ Design Postgres database schemas⚙ Configure database connection pooling
  • db-migration - Safe, reversible, and tested database schema migrations
    databasemigrationschemasql

    ★ 18 · Updated 2026-09-14

    Executes database schema changes through a safe, reversible, and tested migration-first workflow.

    ⚙ Inspect existing database schema⚙ Design backward compatible schema changes⚙ Write forward and rollback migrations
  • snowflake-semanticview - Create, alter, and validate Snowflake semantic views
    snowflakesemantic-viewcliddl

    ★ 0 · Updated 2026-09-14

    Create, alter, and validate Snowflake semantic views using Snowflake CLI, set up connections, and run sample queries.

    ⚙ Verify Snowflake CLI installation⚙ Configure Snowflake connection⚙ Draft semantic view DDL
  • pg-partitioning - Partition PostgreSQL tables and manage partitions.
    postgresqldatabasepartitioningsql

    ★ 0 · Updated 2026-09-13

    Partitions large PostgreSQL tables and manages partition strategies, lifecycles, pruning, and data migrations.

    ⚙ Partition large PostgreSQL tables⚙ Select suitable partitioning strategies⚙ Manage partition lifecycles
  • postgres-patterns - PostgreSQL database patterns and reference
    postgresqldatabasesqlindexing

    ★ 17 · Updated 2026-09-13

    Provides PostgreSQL database patterns for query optimization, schema design, indexing, and security based on Supabase best practices.

    ⚙ Design database schemas⚙ Optimize SQL queries⚙ Create database indexes
  • db-query - Database Query
    databasesqlssh-tunnelmysql

    ★ 10 · Updated 2026-09-12

    Query project databases with automatic SSH tunnel management.

    ⚙ List configured databases⚙ Execute SQL queries⚙ Manage SSH tunnel lifecycle
  • supabase-postgres-best-practices - Supabase Postgres Performance Optimization Guide
    postgressupabaseperformance-optimizationsql

    ★ 0 · Updated 2026-09-11

    Provides Postgres performance optimization rules and best practices for query design, connections, schemas, and configurations.

    ⚙ Optimize SQL queries⚙ Design database schemas⚙ Implement database indexes
  • supabase-postgres-best-practices - Supabase Postgres Performance Best Practices
    postgressupabaseperformancesql

    ★ 0 · Updated 2026-09-11

    Provides Postgres performance optimization guidelines for writing, reviewing, and optimizing queries, schemas, and database configurations.

    ⚙ Optimize Postgres SQL queries⚙ Design database schemas⚙ Review database performance issues
  • Python MySQL Daily ETL Update with Union Logic - Generate Python scripts for daily MySQL ETL updates.
    pythonmysqletlsql

    ★ 1 · Updated 2026-09-11

    Generates Python scripts for daily MySQL database ETL updates using UNION ALL logic and parameterized queries to handle insert and update operations.

    ⚙ Generate Python MySQL ETL scripts⚙ Combine table data using UNION ALL⚙ Execute parameterized SQL queries
  • supabase-migrations - Create and manage Supabase database migrations
    supabasedatabasemigrationmcp

    ★ 602 · Updated 2026-09-10

    Create and manage Supabase database migrations, tables, schemas, and RLS policies using MCP tools.

    ⚙ Apply DDL changes⚙ Execute SQL queries⚙ List existing tables

Scroll to load more