Sql skills

This skill enables OpenClaw to integrate QuickBooks Online for end-to-end accounting, invoicing, payments, inventory, and financial reporting.

This skill guides migrating PostgreSQL tables to TimescaleDB hypertables with configuration, planning, and validation to maximize performance.

This skill guides you to configure pgvector semantic search in PostgreSQL, optimizing recall and speed for large embedding datasets.

This skill helps you design robust PostgreSQL tables by applying best practices for keys, normalization, indexing, constraints, and data types.

This skill helps you design TimescaleDB hypertables with optimal partitioning, compression, retention, and continuous aggregates to improve time-series

This skill analyzes a PostgreSQL schema to identify hypertable candidates and guides migration with TimescaleDB best practices.

This skill analyzes and optimizes SQL queries, providing automated guidance, implementation plans, and validation to boost performance.

This skill retrieves allocation attributes from the ec_distribute.distribute_supply_attribute table for a given demand_id, enabling validation of allocated

This skill helps you design and troubleshoot Kafka Connect pipelines with source and sink connectors, Debezium CDC, and SMT transforms.

This skill helps you design and implement enterprise ASP.NET Core APIs with EF Core, JWT auth, and background services for scalable backends.

This skill helps you design and optimize ksqlDB stream processing workflows with real-time queries, windowing, and materialized views across Kafka topics.

This skill queries the Vanna AI SQL interface in Fuxi to retrieve driving and personnel data using natural language questions.

This skill provides context-aware memory with dual fast and focus modes, enabling fast lookups or curated synthesis using a local SQLite backend.

This skill helps you create, configure, and query Hugging Face datasets with SQL, templates, and streamlined uploads.

This skill helps optimize Postgres queries, schemas, and configs with Supabase best practices to boost performance and security.

This skill analyzes MassGen experiments and logs, generates ANALYSIS_REPORT.md, and guides performance debugging and logging improvements with structured

This skill helps .NET developers implement robust configuration binding, validation, and monitoring using Microsoft.Extensions.Options patterns for reliable

This skill helps you write integration tests using TestContainers for .NET with xUnit against real infrastructure in Docker.

This skill helps you work with Nuxt Content v3 by guiding collections querying rendering and database setup for content-driven apps.

This skill helps you write secure, optimized queries using parameterization, eager loading, and indexing to boost database performance.

This skill guides you to create reversible, well-named migrations with zero-downtime deployment strategies and safe data transformations.