Postgresql Admin
Automates PostgreSQL tasks like backups, schema changes, user management, and query optimization via SQL scripting.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add postgresql-admin npx -- -y @trustedskills/postgresql-admin
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"postgresql-admin": {
"command": "npx",
"args": [
"-y",
"@trustedskills/postgresql-admin"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill provides administrative capabilities for PostgreSQL databases. It allows users to execute SQL commands, manage database objects (like tables and indexes), and perform common maintenance tasks directly through an AI agent interface. The skill aims to simplify PostgreSQL administration by abstracting away the complexities of command-line tools or GUI interfaces.
When to use it
- Database backups: Schedule and initiate regular backups of your PostgreSQL databases.
- Schema changes: Modify database schemas, such as adding new columns to tables, without manual SQL scripting.
- Performance tuning: Analyze query performance and apply optimization techniques like index creation or query rewriting.
- User management: Create, modify, or delete user accounts and manage their permissions within the PostgreSQL system.
Key capabilities
- SQL execution
- Database object management (tables, indexes)
- Backup scheduling
- User account management
Example prompts
- "Create a backup of my 'production_db' database."
- "Add a new column named 'email' to the 'users' table in the 'development_db'."
- "Show me all indexes on the 'products' table."
Tips & gotchas
The skill requires appropriate PostgreSQL credentials (username and password) to be configured beforehand. Ensure that the AI agent has sufficient privileges within the database system to perform the requested actions, as unauthorized operations will fail.
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 Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.