Skip to content

FISCFED9/CLI / .agents/skills/plugins/antigravity-awesome-skills-claude/skills/dbos-python

dbos-python

Verified

Guide for building reliable, fault-tolerant Python applications with DBOS durable workflows. Use when adding DBOS to existing Python code, creating workflows and steps, or using queues for concurrency control.

FileKindSize
AGENTS.mdmarkdown2.7 KB
CLAUDE.mdmarkdown2.7 KB
SKILL.mdskill md2.6 KB
references/_sections.mdmarkdown1.4 KB
references/advanced-async.mdmarkdown2.5 KB
references/advanced-patching.mdmarkdown1.5 KB
references/advanced-versioning.mdmarkdown1.6 KB
references/client-enqueue.mdmarkdown1.4 KB
references/client-setup.mdmarkdown1.6 KB
references/comm-events.mdmarkdown1.5 KB
references/comm-messages.mdmarkdown1.5 KB
references/comm-streaming.mdmarkdown1.5 KB
references/lifecycle-config.mdmarkdown1.5 KB
references/lifecycle-fastapi.mdmarkdown1.5 KB
references/pattern-classes.mdmarkdown1.6 KB
references/pattern-debouncing.mdmarkdown1.6 KB
references/pattern-idempotency.mdmarkdown1.5 KB
references/pattern-scheduled.mdmarkdown1.5 KB
references/pattern-sleep.mdmarkdown1.3 KB
references/queue-basics.mdmarkdown1.3 KB
references/queue-concurrency.mdmarkdown1.3 KB
references/queue-deduplication.mdmarkdown1.6 KB
references/queue-listening.mdmarkdown1.6 KB
references/queue-partitioning.mdmarkdown1.8 KB
references/queue-priority.mdmarkdown1.5 KB
references/queue-rate-limiting.mdmarkdown1.3 KB
references/step-basics.mdmarkdown1.3 KB
references/step-retries.mdmarkdown1.4 KB
references/step-transactions.mdmarkdown1.7 KB
references/test-fixtures.mdmarkdown1.4 KB
references/workflow-background.mdmarkdown1.3 KB
references/workflow-constraints.mdmarkdown1.6 KB
references/workflow-control.mdmarkdown2.0 KB
references/workflow-determinism.mdmarkdown1.3 KB
references/workflow-introspection.mdmarkdown1.8 KB
references/workflow-timeout.mdmarkdown1.4 KB

references/step-transactions.md

View on GitHub
---
title: Use Transactions for Database Operations
impact: HIGH
impactDescription: Transactions provide atomic database operations
tags: transaction, database, postgres, sqlalchemy
---

## Use Transactions for Database Operations

Transactions are a special type of step optimized for database access. They execute as a single database transaction. Only use with Postgres.

**Incorrect (database access in regular step):**

```python
@DBOS.step()
def save_to_db(data):
    # For Postgres, use transactions instead of steps
    # This doesn't get transaction guarantees
    engine.execute("INSERT INTO table VALUES (?)", data)
```

**Correct (using transaction):**

```python
from sqlalchemy import text

@DBOS.transaction()
def save_to_db(name: str, value: str) -> None:
    sql = text("INSERT INTO my_table (name, value) VALUES (:name, :value)")
    DBOS.sql_session.execute(sql, {"name": name, "value": value})

@DBOS.transaction()
def get_from_db(name: str) -> str | None:
    sql = text("SELECT value FROM my_table WHERE name = :name LIMIT 1")
    row = DBOS.sql_session.execute(sql, {"name": name}).first()
    return row[0] if row else None
```

With SQLAlchemy ORM:

```python
from sqlalchemy import Table, Column, String, MetaData, select

greetings = Table("greetings", MetaData(),
    Column("name", String),
    Column("note", String))

@DBOS.transaction()
def insert_greeting(name: str, note: str) -> None:
    DBOS.sql_session.execute(greetings.insert().values(name=name, note=note))
```

Important:
- Only use transactions with Postgres databases
- For other databases, use regular steps
- Never use `async def` with transactions

Reference: [DBOS Transactions](https://docs.dbos.dev/python/reference/decorators#transactions)
receiving-code-reviewobra/superpowersUse when receiving code review feedback, before implementing suggestions, especially if feedback seems unclear or technically questionable - requires technical rigor and verification, not performative agreement or blind implementationStars: 319kUpdated Claude CodeCodexVerifiedInstall
requesting-code-reviewobra/superpowersUse when completing tasks, implementing major features, or before merging to verify work meets requirementsStars: 319kUpdated Claude CodeCodexVerifiedInstall
using-git-worktreesobra/superpowersUse when starting feature work that needs isolation from current workspace or before executing implementation plans - ensures an isolated workspace exists via native tools or git worktree fallbackStars: 319kUpdated Claude CodeCodexVerifiedInstall
verification-before-completionobra/superpowersUse when about to claim work is complete, fixed, or passing, before committing or creating PRs - requires running verification commands and confirming output before making any success claims; evidence before assertions alwaysStars: 319kUpdated Claude CodeCodexVerifiedInstall