databases

Manage PostgreSQL, MongoDB, and Redis via unified CLI workflows.

30|5|Updated Jul 25, 2025
One-click install
npx skills add https://github.com/phuetz/code-buddy --skill databases-phuetz
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: databases
Source: https://github.com/phuetz/code-buddy/tree/main/.codebuddy/skills/bundled/databases
Command: npx skills add https://github.com/phuetz/code-buddy --skill databases-phuetz

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Database administration across PostgreSQL, MongoDB, and Redis often requires switching between tools, duplicating workflows, and manual synchronization. This Skill consolidates routine tasks into a single CLI-driven workflow, reducing context switching and human error.

Core Features & Use Cases

  • Unified CLI control for multiple databases enabling common tasks such as querying, schema discovery, backups, restore, and migrations.
  • MCP server integration to orchestrate database services in local or CI environments.
  • Use Case: During a deployment, quickly backup PostgreSQL, verify MongoDB collections, and warm Redis caches with a single command.

Quick Start

Install and configure environment variables POSTGRES_URL, MONGODB_URI, REDIS_URL, then run the included CLI tools (psql for PostgreSQL, mongosh for MongoDB, and redis-cli for Redis) to perform routine operations. For example: set POSTGRES_URL and run a simple query with psql "$POSTGRES_URL" -c "SELECT version();"

Frequently Asked Questions about databases

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I manage PostgreSQL, MongoDB, and Redis from a single CLI workflow?

You can manage PostgreSQL, MongoDB, and Redis from a single CLI workflow by configuring environment-based connection strings like POSTGRES_URL, MONGODB_URI, and REDIS_URL to execute queries, backups, and restores. This consolidated approach eliminates context switching between separate database administration tools.

Can I use CLI tools to backup PostgreSQL and warm Redis caches during a deployment?

Yes, you can use CLI tools to backup PostgreSQL, verify MongoDB collections, and warm Redis caches during a deployment. By orchestrating psql, mongosh, and redis-cli through a unified command structure, you can sequence these cross-database operations efficiently.

What environment variables do I need to set up cross-database CLI management?

To set up cross-database CLI management, you must configure the POSTGRES_URL, MONGODB_URI, and REDIS_URL environment variables. These connection strings allow the CLI tools to authenticate and interact with your PostgreSQL, MongoDB, and Redis instances.

Does this database management approach support MCP server integration for CI environments?

Yes, this database management approach supports MCP server integration to orchestrate database services in local or CI environments. This allows you to automate connection setup, query execution, and data export tasks across PostgreSQL, MongoDB, and Redis.

What is the best way to run schema discovery and queries across multiple databases?

The best way to run schema discovery and queries across multiple databases is using a unified CLI tool that leverages psql for PostgreSQL, mongosh for MongoDB, and redis-cli for Redis. This method enforces standard admin commands and simplifies data export and import tasks.