How do I install the Turbopg skill?

Run npx skillmds@latest add justrach/turbopg in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Turbopg safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Turbopg?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Turbopg free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Turbopg?

justrach (@justrach) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Turbopg by justrach — Agent Skill

Name: Turbopg
Author: justrach

File contents

TurboPG — Standalone Postgres Client

TurboPG ships with TurboAPI and works independently for any Python Postgres work.

Quick start

from turbopg import Database

db = Database("postgres://user:pass@localhost/mydb", pool_size=16)

# Multiple rows
users = db.query("SELECT * FROM users WHERE age > $1 LIMIT $2", [18, 10])

# Single row (or None)
user = db.query_one("SELECT * FROM users WHERE id = $1", [42])

# Execute (INSERT/UPDATE/DELETE) — returns affected row count
db.execute("INSERT INTO users (name, email) VALUES ($1, $2)", ["Alice", "a@b.com"])
affected = db.execute("DELETE FROM users WHERE id = $1", [99])

# Context manager
with Database("postgres://...") as db:
    count = db.query_one("SELECT count(*) as n FROM users")

Parameters

Use $1, $2, ... for parameterized queries (Postgres-native, SQL injection safe):

db.query("SELECT * FROM users WHERE name = $1 AND age > $2", ["Alice", 18])

Return types

query() → list[dict] — each row as a dict with column names as keys
query_one() → dict | None — first row or None
execute() → int — number of affected rows
Decimals → float, datetimes → ISO string, memoryview → decoded string

Connection modes

With TurboAPI installed: Uses Zig pg.zig connection pool (zero overhead for TurboAPI db routes)
Standalone: Falls back to psycopg2/psycopg (requires pip install psycopg2-binary)

Unix sockets

db = Database("postgres://user:pass@/var/run/postgresql/mydb")

With TurboAPI

TurboPG powers TurboAPI's db_get, db_post, db_list, db_delete, and db_query decorators. The Zig-native path runs the entire request cycle without Python.

---name: turbopgdescription: Use TurboPG for standalone Postgres queries. Use when writing database code outside of TurboAPI routes, running migrations, seeding data, or building scripts that talk to Postgres.---# TurboPG — Standalone Postgres ClientTurboPG ships with TurboAPI and works independently for any Python Postgres work.## Quick start```pythonfrom turbopg import Databasedb = Database("postgres://user:pass@localhost/mydb", pool_size=16)# Multiple rowsusers = db.query("SELECT * FROM users WHERE age > $1 LIMIT $2", [18, 10])# Single row (or None)user = db.query_one("SELECT * FROM users WHERE id = $1", [42])# Execute (INSERT/UPDATE/DELETE) — returns affected row countdb.execute("INSERT INTO users (name, email) VALUES ($1, $2)", ["Alice", "a@b.com"])affected = db.execute("DELETE FROM users WHERE id = $1", [99])# Context managerwith Database("postgres://...") as db: count = db.query_one("SELECT count(*) as n FROM users")```## ParametersUse `$1`, `$2`, ... for parameterized queries (Postgres-native, SQL injection safe):```pythondb.query("SELECT * FROM users WHERE name = $1 AND age > $2", ["Alice", 18])```## Return types- `query()` → `list[dict]` — each row as a dict with column names as keys- `query_one()` → `dict | None` — first row or None- `execute()` → `int` — number of affected rows- Decimals → `float`, datetimes → ISO string, memoryview → decoded string## Connection modes1. **With TurboAPI installed**: Uses Zig pg.zig connection pool (zero overhead for TurboAPI db routes)2. **Standalone**: Falls back to psycopg2/psycopg (requires `pip install psycopg2-binary`)## Unix sockets```pythondb = Database("postgres://user:pass@/var/run/postgresql/mydb")```## With TurboAPITurboPG powers TurboAPI's `db_get`, `db_post`, `db_list`, `db_delete`, and `db_query` decorators. The Zig-native path runs the entire request cycle without Python.

Frequently asked questions

Turbopg