Postgres Wizard
CheckedGenerates complex PostgreSQL queries, optimizes existing ones, and troubleshoots errors with expert precision.
Install on your platform
Showing Claude Code. One command installs this skill into any of the agents below.
- 1
Run this in your project
terminal$ npx skills add omer-metin/skills-for-antigravity --skill postgres-wizard -a claude-code Uses the open-source
skillsCLI and needs Node.js. Add-gto install it for your user instead of this project.
What we know about this skill
Publisher
omer-metin
Taken from the source listing. We haven't verified who controls this account.
Install target
Live repository
Not pinned. Installing fetches whatever the repository holds at the time you run the command.
Automated safety checks
This skill passed all 6 checks. We read its files at one commit and looked for the things that make a skill dangerous to run — not for whether it works.
Declares what it does: passed
SKILL.md parses and declares a name and a description.
SKILL.md exists, its frontmatter parses, and it declares a name and a description.
No undeclared network calls: passed
Makes no network calls.
Every host the skill dials — from its scripts, its config endpoints or the commands it tells the agent to run — is either well-known package and API infrastructure or declared in its own frontmatter. Links in documentation are not counted.
No obfuscated payloads: passed
No encoded or obfuscated payloads.
No base64, hex or compressed blob is decoded and then executed, and no encoded shell commands.
No credential access: passed
Reads no keys, tokens, keychains or credential files.
Neither the code nor the SKILL.md instructions read SSH keys, cloud credentials, keychains, token stores, browser cookie databases or dotfiles that hold secrets.
No pipe-to-shell installers: passed
No pipe-to-shell or download-and-run installers.
No `curl … | sh` pattern, in the code or in the instructions, that runs code fetched at run time.
Pinned to a commit: passed
Scanned omer-metin/skills-for-antigravity at e8dcf4e873.
The exact upstream commit SHA that was scanned is recorded, so the result refers to specific bytes.
- Commit
- e8dcf4e873
- Manifest
- skills/postgres-wizard/SKILL.md
- Scanned
- 4 files, 919 lines
About this skill
What it does
The postgres-wizard skill allows AI agents to interact with and manipulate PostgreSQL databases. It can execute SQL queries, retrieve data, and perform database administration tasks like creating tables or updating schemas. This skill is designed for scenarios requiring programmatic access and management of PostgreSQL data stores.
When to use it
- Data Extraction: Retrieve specific information from a PostgreSQL database based on complex criteria (e.g., "Get all customers who placed an order in the last month").
- Database Schema Modification: Automatically create or alter tables, indexes, and other schema elements based on requirements (e.g., "Add a new column 'email' to the 'users' table").
- Data Analysis & Reporting: Generate reports by querying data from PostgreSQL databases and presenting it in a structured format.
- Automated Database Maintenance: Execute routine tasks like backups or index optimization scripts within a PostgreSQL environment.
Key capabilities
- SQL query execution
- Database schema modification (create/alter tables)
- Data retrieval
- Database administration tasks
Example prompts
- "Run the following SQL query:
SELECT * FROM products WHERE price > 100" - "Create a table named 'orders' with columns for order_id, customer_id, and order_date."
- “What is the total number of users in the ‘users’ table?”
Tips & gotchas
The agent needs access to a PostgreSQL database instance. Ensure proper credentials (host, port, username, password) are provided for successful interaction with the database.