Skip to content

pratyushdeosingh/mdp / .agents/skills/dbos-python

dbos-python

Verified

DBOS Python SDK for building reliable, fault-tolerant applications with durable workflows. Use this skill when writing Python code with DBOS, creating workflows and steps, using queues, using DBOSC...

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)
reverse-engineer-anythingmorluto/reaReverse engineer native, managed, Electron/JavaScript, packaged, firmware, and browser targets with REA, and build agent environments (AgentEnv bundles) of web applications from a live instance or a capture, and of Linux desktop apps with a task from a request. Use shipped-artifact or requested runtime evidence to explain features, compare versions, decompile code, or guide a reconstruction. Skip REA for ordinary source-repository architecture analysis.Stars: 470kUpdated Claude CodeCodexVerifiedInstall
diagnosing-superpowersobra/superpowersUse when a superpowers session went wrong and your human partner wants to know why — repeated work, ignored plans, stumbles, poor results, a skill that didn't fire, "it took too long", "why is it so expensive", "what is it doing" — or wants to build a bug report for the superpowers maintainers, for the current session or a past one identified by id or path, on any harness.Stars: 322kUpdated Claude CodeCodexVerifiedInstall
dispatching-parallel-agentsobra/superpowersUse when facing 2+ independent tasks that can be worked on without shared state or sequential dependenciesStars: 322kUpdated Claude CodeCodexVerifiedInstall
executing-plansobra/superpowersUse when executing an implementation plan in the current session as the implementer yourself — your human partner chose inline execution, or no subagent tool is availableStars: 322kUpdated Claude CodeCodexVerifiedInstall