ensure_postgres

MCP tool from Pgsandbox by LVTD-LLC

Install missing local Postgres server binaries with a supported package manager when available, then start a managed local profile.

How to use it

Project documentation lists ensure_postgres for the Pgsandbox MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), then check which tools your installed version makes available. Tool availability can depend on configuration and credentials. A server handshake does not verify this tool’s behavior. See the full listing for setup details.

Install Pgsandbox

$cargo install --path . --force
FULL PGSANDBOX LISTING

Other tools in Pgsandbox (26)

cleanup_expired

Delete expired metadata-owned sandboxes, or dry-run the selection.

clone_database

Clone an existing source database into a new sandbox with pgdump/pgrestore, optionally installing target extensions and skipping source-only extension entries.

create_database

Create one isolated sandbox database and role, optionally installing requested extensions.

create_sandbox_from_template

Restore a template into a new tracked sandbox.

create_schema_snapshot

Store a named local schema checkpoint.

create_template_from_sandbox

Export a sandbox to a reusable local template artifact.

delete_database

Delete a metadata-owned sandbox database and role.

delete_schema_snapshot

Delete a local schema snapshot artifact.

delete_template

Delete a template dump and metadata.

describe_schema

Return relation, column, constraint, index, view, materialized view, foreign table, and extension metadata.

diff_schema_snapshot

Compare a stored snapshot with the current schema.

doctor

Return MCP-safe diagnostics and profile health.

explain_query

Return EXPLAIN (FORMAT JSON) for one safe plannable statement.

get_connection_string

Return redacted direct/container connection variants by default, or raw credentials when explicitly requested.

list_databases

List active metadata-owned sandboxes.

list_extensions

List available extensions for a profile and installed extensions for an existing sandbox.

list_profiles

List configured profiles and discovered local Postgres versions.

list_schema_snapshots

List named schema checkpoints for a sandbox.

list_templates

List local template artifacts for a profile.

prepare_for_repo

Write secret-free repo workflow metadata to .pgsandbox/project.json.

run_repo_command

Run an explicit repo command with sandbox DB env vars.

run_sql

Run SQL against a sandbox with bounded result rows.

schema_diff

Compare a previous digest with the current schema.

schema_digest

Return a compact checksummed schema summary.

seed_database

Run an explicit seed command against a sandbox.

validate_schema_change

Capture before/after schema digests around a repo command.