Databases Agent Skills for Perplexity

The First Brain for OpenClaw. Your agents forget everything after each session — BrainX fixes that permanently.\n Persistent vector memory…

Build out the transformation layers (`staging/`, `intermediate/`) of a data product and run dbt against them, following project-wide…

Build zero-downtime database migrations — forward SQL, rollback SQL, deployment sequence.

Use when creating or modifying dbt Semantic Layer components — semantic models, metrics, dimensions, entities, measures, or time spines.

Redis patterns: caching, sessions, rate limiting, pub/sub, queues, distributed locks — with Python and Node.js examples

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

MUST USE when designing ClickHouse architectures, selecting between ingestion or modeling patterns, or translating best practices into…

10+ patterns for ClickHouse Materialized Views.

Write idiomatic application code with the ClickHouse Node.js client (`@clickhouse/client`).

Optimize ClickHouse query performance with indexing, projections, settings tuning, and query analysis using system tables.

Provides comprehensive guidance for Azure SQL Database including database creation, configuration, security, and Azure SQL management.

Use CloudBase document database Web SDK to query, create, update, and delete data.

Cloudflare D1 serverless SQLite on edge.

Set up or troubleshoot MotherDuck connections, authentication, client runtimes, and read scaling.

Safely migrate Convex schemas and data when making breaking changes.

ONLY load this skill when the user explicitly types $cortex-run or /cortex-run.

Auto-routing skill loaded by the prompt filter hook.

Implements high-performance data access layers using Repository patterns and ORM best practices across multiple programming languages.

Data architecture patterns (warehouse, lake, lakehouse, mesh), ETL/ELT pipelines, streaming architectures, scaling strategies, and schema…

Automate update and maintenance of data dictionaries in Treasure Data - generates 80-90% of column descriptions automatically, allowing…

Review data integrity for Rails changes.