Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    Nex Postgres Multi Instance

    5

    Manage multiple Postgres versions and extensions on one Linux box with a port registry and unified backups.

    $9

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    2 usesSecurity scanned
    nex-postgres-multi-instance

    nex-postgres-multi-instance

    Example session with this skill installed

    I need to add a pgvector instance for a new project called 'brain-search' on my Ubuntu box. Port 5432 is already taken by my main app.

    • Read your context and instructions
    • Compiled the nex-postgres-multi-instance

    I've generated the postgres-multi/ package. I've assigned 'brain-search' to port 5433 (the next free port in your registry) using the docker-pgvector template.

    Registry Entry added
    5433 | brain-search-db | brain-search | pgvector pg16 | docker | 2024-05-20

    Run this to start
    docker compose -f postgres-multi/docker-instances/docker-compose-brain-search.yml up -d

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Run Multiple Postgres Instances Peacefully

    Running multiple databases on a single Linux machine often leads to port collisions, authentication headaches ("Peer authentication failed"), and backup gaps. This skill implements a battle-tested operational pattern for developers who need to host multiple isolated Postgres environments—such as pgvector, TimescaleDB, and vanilla Postgres—side-by-side without version conflicts or high managed-database bills.

    What it does

    The skill generates a hard-coded infrastructure folder (postgres-multi/) containing everything needed to manage your database fleet:

    • Port Registry: A canonical mapping to prevent port collisions between services.
    • Multi-Instance Configs: Templates for both Debian-managed clusters and Docker containers (pgvector, TimescaleDB, vanilla).
    • Hardened Security: Automatic 127.0.0.1 binding and SCRAM-SHA-256 authentication setup to prevent credential-spraying.
    • Unified Backups: A central shell script that iterates through your registry to perform gzipped nightly dumps with auto-pruning.
    • Fix Scripts: One-shot utilities to resolve common "peer authentication" issues and check port availability.

    Why use this skill?

    Unlike a generic AI prompt, this skill enforces strict operational standards: it ensures every volume is app-prefixed to prevent accidental data deletion, insists on non-root app roles, and provides a documented upgrade path for when the next Postgres major version ships. It transforms a messy "db-on-a-box" setup into a professional, registry-backed database platform.

    Built by Nex AI. More skills and info at nex-ai.be and slopsome.com.

    • Local storage only: does not include off-site or S3 syncing. - Single-node focus: not for clusters like Patroni. - Linux-specific: relies on Debian/Ubuntu systemd and Docker setup.

    Open docs

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    2 uses

    Times used to date

    Money-back guarantee

    Doesn't do what its page promises? You get your money back.

    Trust & safety

    Security scan

    Security scan passed 3 months ago

    Permissions

    Terminal / Shell
    Listed5 months ago
    Updated3 months ago

    What's inside

    Frequently Asked Questions

    This skill is designed for any Linux environment running Debian-based distributions or Docker environments, making it compatible with most VPS providers and local servers.

    The skill generates a structured 'postgres-multi/' directory containing a port registry, configuration templates for various Postgres flavors (like pgvector and TimescaleDB), unified backup scripts, and automated security hardening utilities.

    The skill solves port collision errors and authentication failures ('Peer authentication failed') by implementing a centralized Port Registry and standardizing SCRAM-SHA-256 headers across all instances.

    Yes, the skill includes a unified backup script that automatically discovers all registered instances, performs gzipped dumps, and manages retention through automated pruning.

    Absolutely—the skill includes dedicated templates for pgvector and TimescaleDB, allowing you to run these specialized engines side-by-side with vanilla Postgres without versioning conflicts.

    Once purchased, you can run the skill whenever you need to add a new instance to your registry or refresh your configuration templates for a new Postgres major version.

    New in Data & Databases