PostgreSQL deep-dive: EXPLAIN ANALYZE interpretation, index types (B-tree, GIN, GiST, BRIN), partial/covering/composite indexes…
Comprehensive guide for migrating PostgreSQL tables to TimescaleDB hypertables with optimal configuration and performance validation
Guides tenant isolation architecture in Qdrant for multi-tenant or multi-user applications.
Deploys and manages Qdrant vector databases on Railway for AI-powered semantic search and RAG applications.
This skill should be used when the user wants to add a database (Postgres, Redis, MySQL, MongoDB), says "add postgres", "add redis", "add…
Redis Cluster and replication guidance covering hash tags for multi-key operations, avoiding CROSSSLOT errors, and reading from replicas…
Enforces Redis best practices and safety standards to prevent production performance bottlenecks and data management risks.
Relational database implementation across Python, Rust, Go, and TypeScript.
Config-first setup wizard for a remindb MCP server — run it as `/remindb-setup` (interactive), `/remindb-setup automode` (hands-off), or…
Deep operational guide for 12 NewSQL/distributed SQL databases.
Use when designing Salesforce custom objects, relationships, Custom Metadata, or sharing models for scalable org architecture.
Trace data lineage, source attribution, audit trails, and provenance assertions in Semantica graphs.
Query the Semantica knowledge graph using SPARQL, Cypher, keyword search, and structured graph query patterns.
Design data movement and transformation pipelines.
Configure and manage Snowflake connections for CLI tools, Streamlit apps, dbt, and Snowpark applications.
Provides Spring Data Neo4j integration patterns for Spring Boot applications.
Optimize SQL query performance through EXPLAIN analysis, indexing strategies, and query rewriting for PostgreSQL, MySQL, and SQL Server.
Use when: comparing SQL Server tables across instances, data migration validation, ETL verification, row mismatch detection, schema drift…
How to store application data in agent-native apps.
Complete T-SQL function reference for SQL Server and Azure SQL Database.
Adds Data Vault 2 technical tests to a datavault4dbt project — hashkey uniqueness and not-null, link-to-hub referential integrity, and…