postgres-query
CommunityQuery PostgreSQL in Docker containers instantly.
Authorracar
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill eliminates the manual overhead of running ad-hoc SQL against PostgreSQL databases that are containerized. It can automatically locate running PostgreSQL containers and route your queries to the correct database for inspection and modification.
Core Features & Use Cases
- Automatic container detection: finds running PostgreSQL containers and uses docker exec to reach psql.
- Support for all SQL operations: executes SELECT, INSERT, UPDATE, and DELETE across databases.
- Ad-hoc analysis and data modification: ideal for quick data checks, debugging, and validating migrations inside containers.
Quick Start
Run the query tool to execute a SQL statement against a containered PostgreSQL database:
- Use scripts/query_db.sh <database_name> "<sql_query>" to run a single query.
- If multiple containers are running, pass the container_id as the third argument.
Dependency Matrix
Required Modules
dockerpsql
Components
scriptsreferences
💻 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: postgres-query Download link: https://github.com/racar/racar_agent_skills/archive/main.zip#postgres-query Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.