Databases Agent Skills

[Deprecated] Optional advanced tool for complex data modeling.

[Deprecated] This is the required documentation for agents operating on the CloudBase Relational Database through MCP.

End-to-end ArcGIS Portal / AGOL → CARTO migration.

Import geospatial files into the data warehouse via CARTO, export results back out, and prepare tilesets for fast map rendering.

When to activate: Cassandra, CQL, partition key, wide row, Cassandra cluster, eventual consistency, Scylla

Help with CDS (Core Data Services) view entity development including data modeling, annotations, associations, compositions, access…

Use when adding/modifying database columns, encountering "FOREIGN KEY constraint failed", "no such column", "cannot add NOT NULL column"…

Define what the system knows and what crosses its boundaries — a conceptual entity diagram, field-level ER + YAML contract sheet when…

Supabase: Row Level Security policies, auth integration, realtime subscriptions, Storage, Edge Functions, pgvector

Turso: embedded SQLite for the edge — database setup, LibSQL client, schema design, multi-tenancy patterns, and deployment with Cloudflare…

SQLite database migration patterns for SpecFlux.

Printing Press CLI for Clickhouse Cloud.

Optimize ClickHouse Cloud costs — compute scaling, storage tiering, compression, and query efficiency for lower bills.

Ingest data into ClickHouse from webhooks, Kafka, and streaming sources with batching, dedup, and exactly-once patterns.

Configure ClickHouse enterprise RBAC — SQL-based users, roles, row policies, column-level grants, and quota management.

When to activate: ClickHouse, columnar, analytics, OLAP, MergeTree, materialized view, dictionaries, CHProxy

Production readiness checklist for ClickHouse — server tuning, backup, monitoring, and deployment verification.

Skill for analyzing and optimizing ClickHouse queries in go-ch-manager.

20+ optimization rules for ClickHouse queries.

Use when upgrading ClickHouse server versions or the @clickhouse/client SDK, handling breaking changes between versions, or migrating from…

Designs database schemas, indexing strategies, query optimization, and migration patterns for SQL and NoSQL databases.