Execute SQL queries and manage PostgreSQL database schemas.
npx skills add https://github.com/zangxin75/openclaw-skills --skill postgres-zangxin75
Please help me install this Agent Skill. Skill: postgres Source: https://github.com/zangxin75/openclaw-skills/tree/main/postgres Command: npx skills add https://github.com/zangxin75/openclaw-skills --skill postgres-zangxin75
This Skill simplifies the management of PostgreSQL databases, allowing users to execute queries, manage schemas, and monitor performance without needing deep SQL expertise.
Use the postgres skill to run the query: SELECT * FROM users LIMIT 10.
High-intent search queries and answers about installing and using this skill.
To execute SQL queries against a PostgreSQL database, you can use this Skill to run custom SELECT statements directly. It manages database interaction by securely connecting via a configured DATABASE_URL environment variable to retrieve or manipulate your data.
Managing PostgreSQL schemas involves creating, altering, and dropping database structures. This Skill handles schema management tasks directly, allowing you to modify table structures and organize your database schema without needing deep SQL expertise.
You can monitor PostgreSQL performance to identify and optimize slow-running queries. The Skill provides performance monitoring capabilities to help you analyze query execution, pinpoint bottlenecks, and streamline database operations.
Yes, managing PostgreSQL databases with this Skill requires a configured DATABASE_URL environment variable. This secure connection string is necessary for executing commands, running queries, and performing administrative tasks.
The best way to retrieve recent records from a PostgreSQL database is to run a custom SQL query. For example, you can ask the Skill to show all users registered in the last 30 days, and it will execute the query directly against your database.
The primary limitation for PostgreSQL database administration is the strict requirement for a DATABASE_URL environment variable. Without this secure connection configured, the Skill cannot execute SQL queries, manage schemas, or monitor performance.
Hamza123545Configure Neon serverless PostgreSQL connections with HTTP or pooling drivers.
bytedanceAnalyzes Excel and CSV files with DuckDB SQL queries and exports results to CSV, JSON, or Markdown.
7a336e6eEncrypt sensitive columns and enable PostgreSQL Row-Level Security for tenant isolation.
htlin222Develop and optimize SQL queries, design schemas, and advise on indexing strategies.
