# Postgres

> PostgreSQL database management. Run queries, manage schemas, and monitor performance.

- Skill: `thinkfleetai/postgres` (Agent Skill)
- Install (CLI): `npx skillmds@latest add thinkfleetai/postgres`
- Raw SKILL.md: https://api.skillmd.com/api/skills/thinkfleetai/postgres/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: thinkfleetai (https://skillmd.com/u/thinkfleetai)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/thinkfleetai/postgres

---


# PostgreSQL 🐘

PostgreSQL database management.

## Setup

```bash
export DATABASE_URL="postgresql://user:pass@localhost:5432/dbname"
```

## Features

- SQL query execution
- Schema management
- Index optimization
- Backup and restore
- Performance monitoring
- Extensions management

## Usage Examples

```
"Show all tables"
"Run query: SELECT * FROM users"
"Create index on email column"
"Show slow queries"
```

## Commands

```bash
psql "$DATABASE_URL" -c "SELECT * FROM users LIMIT 10"
```

## Safety Rules

1. **ALWAYS** confirm before destructive operations
2. **BACKUP** before schema changes