Cross Env Postgresql Extensions

🌐Community
by jovermier · vlatest · Repository

Installs and configures PostgreSQL extensions across diverse environments using pre-defined configurations from jovermier.

Install on your platform

We auto-selected Claude Code based on this skill’s supported platforms.

1

Run in terminal (recommended)

terminal
claude mcp add cross-env-postgresql-extensions npx -- -y @trustedskills/cross-env-postgresql-extensions
2

Or manually add to ~/.claude/settings.json

~/.claude/settings.json
{
  "mcpServers": {
    "cross-env-postgresql-extensions": {
      "command": "npx",
      "args": [
        "-y",
        "@trustedskills/cross-env-postgresql-extensions"
      ]
    }
  }
}

Requires Claude Code (claude CLI). Run claude --version to verify your install.

About This Skill

What it does

This skill allows you to automatically configure and enable PostgreSQL extensions within your development environment. It simplifies the process of adding functionality like PostGIS for geospatial data or hstore for key-value pair storage directly into your database. The skill handles setting up the necessary environment variables and executing SQL commands to install and activate these extensions.

When to use it

  • You need to quickly enable PostGIS for working with geographic data in a PostgreSQL database.
  • You're starting a new project that requires hstore functionality for storing flexible data structures.
  • You want to automate the process of adding common PostgreSQL extensions across multiple development environments.
  • You are setting up a testing environment and need specific extensions enabled for test cases.

Key capabilities

  • Automatic extension installation
  • Environment variable configuration
  • SQL command execution for enabling extensions
  • Support for various PostgreSQL extensions (specific list not provided)

Example prompts

  • "Enable the PostGIS extension in my database."
  • "Install and activate the hstore extension."
  • “Configure my environment to use the pg_trgm extension.”

Tips & gotchas

  • Ensure you have PostgreSQL installed and accessible before using this skill.
  • The specific extensions supported are not detailed in the provided source, so verify compatibility beforehand.

Tags

🛡️

TrustedSkills Verification

Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.

Security Audits

Gen Agent Trust HubPass
SocketPass
SnykPass

Details

Version
vlatest
License
Author
jovermier
Installs
2

🌐 Community

Passed automated security scans.