In-memory caching in Golang using samber/hot — eviction algorithms (LRU, LFU, TinyLFU, W-TinyLFU, S3FIFO, ARC, TwoQueue, SIEVE, FIFO)…
usql is a universal command-line interface for SQL databases including PostgreSQL, MySQL, SQLite, Oracle, SQL Server, and dozens more.
Connect to live PostgreSQL database to validate schema assumptions, compare pg_dump vs pgschema output, and query system catalogs…
This skill utilizes the data-validation-engine plugin to ensure database integrity.
Vector database operations for embeddings and semantic search.
Work with the @upstash/vector TypeScript/JavaScript SDK, a serverless vector database for embeddings, similarity search, semantic search…
Veeva Vault migration deep dive for enterprise operations.
Integrate Redis-compatible Vercel KV for caching, session management, and rate limiting in Next.js applications.
ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
Use when preparing a PVLDB artifact for the pVLDB Reproducibility Evaluation or the ACM availability badge, covering the mandatory…
Use when engineering reproducibility into a VLDB paper before submission, covering hardware and configuration disclosure, dataset and…
Universal database IDE CLI — query PostgreSQL, MySQL, SQLite, BigQuery, MongoDB with cost projection
Design, review, and execute safe database schema changes and data backfills with zero-downtime compatibility staging and lock-aware…
Diagnoses and guides Qdrant horizontal scaling decisions.
Guides Qdrant vertical scaling decisions.
Windows and Git Bash path handling for SSDT, SqlPackage, and DACPAC files.
Use when setting up workspace and branch context, switching workspaces or branches, creating or deleting branches, reviewing branch…
Download data from the WRDS (Wharton Research Data Services) PostgreSQL database to local Parquet or CSV files.
This skill should be used when the user asks "should I use an LSM or a B-tree", "why is disk usage far bigger than my data", "why do…
Write optimized SQL for your dialect with best practices.
Guide for writing performant ClickHouse queries in PostHog product code.