Execute SQL statements in PostgreSQL containers via automatic container detection.
npx skills add https://github.com/racar/racar_agent_skills --skill postgres-query
Please help me install this Agent Skill. Skill: postgres-query Source: https://github.com/racar/racar_agent_skills/tree/main/skills/postgres-query Command: npx skills add https://github.com/racar/racar_agent_skills --skill postgres-query
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.
Run the query tool to execute a SQL statement against a containered PostgreSQL database:
High-intent search queries and answers about installing and using this skill.
You can execute SQL by passing the database name and query string to the query script, which automatically detects the running PostgreSQL container and routes the command via docker exec.
Yes, the tool supports SELECT, INSERT, UPDATE, and DELETE operations, allowing you to perform ad-hoc data modification and debugging directly inside the containerized PostgreSQL database.
Yes, you need both Docker and the PostgreSQL client (psql) installed locally, as the tool relies on docker exec to route your SQL statements through psql inside the targeted container.
If multiple PostgreSQL containers are running, pass the specific container_id as the third argument to the query script to ensure the SQL statement targets the correct database instance.
Automatic container detection finds running PostgreSQL containers and uses docker exec to reach psql internally, eliminating the manual overhead of specifying connection parameters for ad-hoc data inspection.
The approach is constrained to running containerized PostgreSQL instances and requires the Docker environment with psql available, meaning it cannot query remote non-containerized databases directly.
ZanebonoAlterDiagnose Syntopica backend issues by querying PostgreSQL in a Docker container.
besoeasyQuery SQLite, PostgreSQL, and MySQL databases and export results to CSV or JSON.
pacphiManage the VisionFlow container lifecycle and execute in-container commands via Docker socket.
tehnplkManage PostgreSQL databases inside Docker containers using psql commands.
