Skills
.Work. You
Rest

managing-databases

Community

Guide multi-database architectures with confidence.

Software Engineering#architecture#database#PostgreSQL#Parquet#DuckDB#vector-search#PGVector
Authorrileyhilliard
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill provides structured guidance for architectural decisions across PostgreSQL, DuckDB, Parquet, and PGVector, helping teams design scalable, maintainable data platforms.

Core Features & Use Cases

  • Cross-database design patterns for OLTP, OLAP, and vector search workloads.
  • Hybrid storage and maintenance tuning recommendations, covering schema, indexing, partitioning, and data layout.
  • Use case: plan a multi-database stack that supports transactional workloads in PostgreSQL, analytic workloads in DuckDB, storage in Parquet, and vector search in PGVector.

Quick Start

Ask for a cross-database architecture proposal for a new application using PostgreSQL for metadata, DuckDB for analytics, Parquet for storage, and PGVector for embeddings.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: managing-databases
Download link: https://github.com/rileyhilliard/claude-essentials/archive/main.zip#managing-databases

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.