How long does the integration take?

Change one base URL in an OpenAI-compatible client, or install the Python or TypeScript SDK; the quickstart routes a first request in a few minutes.

Will this lock us into another vendor?

No. The router is Apache-2.0 open source, your provider keys stay yours, and the API is OpenAI-compatible, so leaving is a change of base URL.

What happens when a provider fails?

The router falls back to the next model your policy allows and records the fallback in the trace, so an outage costs a retry, not an incident.

db-sqlalchemy - Agent - OpenSmartRoute

Name: db-sqlalchemy
Author: fredisbusy

Claude Code subagent imported from fredisbusy/agent-crossing (.claude/agents/db-sqlalchemy.md). Copyright stays with the author.

You work on packages/backend/src/db/models.py(SQLAlchemy ORM models) and packages/backend/alembic/(migrations) — the single source of truth for the PostgreSQL + pgvector store shared by the backend memory system. Prisma has been retired (docs/architecture-analysis/02_design.md §4.5); SQLAlchemy + Alembic own the schema end to end, no second schema definition to keep in sync.

Rules

스키마 변경은 항상 db/models.py를 먼저 고치고, pnpm db:revision "설명"으로 Alembic 리비전을 autogenerate한 뒤 커밋에 함께 포함한다. 수동으로 DB를 건드리지 않는다.
CHECK 제약조건, 인덱스, partial unique index 등은 마이그레이션 SQL에만 두지 않고 db/models.py의 __table_args__에도 선언해, ORM 레벨에서 눈에 보이게 유지한다.
pgvector 컬럼(Vector(EMBEDDING_DIMENSION))의 차원은 settings.py의 EMBEDDING_DIMENSION 상수를 항상 참조한다 — 하드코딩된 정수를 새로 추가하지 않는다.
pgvector 관련 컬럼/인덱스 변경은 packages/backend/src/agents/memory/의 retrieval 코드와 SPEC.md의 retrieval 정의에 영향을 주는지 먼저 확인한다.
스키마와 packages/shared의 타입이 어긋나지 않도록 함께 갱신한다.

Verification

pnpm db:revision "설명" → 생성된 리비전 파일을 검토 → 로컬 DB에 uv run --project packages/backend alembic -c packages/backend/alembic.ini upgrade head로 적용 → pnpm db:status로 확인. 마이그레이션이 backend 코드에 영향을 준다면 uv run pytest packages/backend/tests도 실행한다.

# after Install: the listing is in your workspace's routing pool - nothing else to configure curl -s -X POST https://api.opensmartroute.ai/api/v1/route -H 'Authorization: Bearer $OSR_API_KEY' -H 'Content-Type: application/json' -d '{"text": "...", "plan": true}' # or pin it on the OpenAI-compatible endpoint: {"model": "fredisbusy-agent-crossing-db-sqlalchemy-subagent", ...}

Install db-sqlalchemy and it becomes one more candidate the router can pick - when it fits.

A listing is a routing target with a manifest: what it does, which domains it covers, what it costs and who publishes it. Once installed it sits beside your own models and tools, is scored like any other candidate for each request, and shows up in the trace when it wins. Ratings come from workspaces that installed it, one per account.

{ "ocm": "1", "id": "fredisbusy-agent-crossing-db-sqlalchemy-subagent", "kind": "agent", "name": "db-sqlalchemy", "description": "Use for database schema/migration work — SQLAlchemy models (packages/backend/src/db/models.py) and Alembic migrations (packages/backend/alembic/), and their downstream impact on the memory/retrieval system (pgvector) and packages/shared types.", "publisher": "fredisbusy", "version": "1.0.0", "capabilities": { "domains": [ "coding" ], "tags": [ "agent-md", "github-claude-agents" ], "languages": [ "en" ] }, "quality_prior": 0.6, "examples": [ "Use for database schema/migration work — SQLAlchemy models (packages/backend/src/db/models.py) and Alembic migrations (packages/backend/alembic/), and their downstream impact on the memory/retrieval system (pgvector) and packages/shared types." ], "primary": false, "metadata": { "source": { "provider": "github-claude-agents", "repository": "https://github.com/fredisbusy/agent-crossing", "path": ".claude/agents/db-sqlalchemy.md", "ref": "b35cbed43b2bb505e3e3bd88fe4a731e1f7e8a82", "url": "https://github.com/fredisbusy/agent-crossing/blob/b35cbed43b2bb505e3e3bd88fe4a731e1f7e8a82/.claude/agents/db-sqlalchemy.md", "key": "fredisbusy/agent-crossing/.claude/agents/db-sqlalchemy.md" }, "tools": [ "Read", "Edit", "Write", "Bash", "Grep", "Glob" ] }, "instructions": "You work on `packages/backend/src/db/models.py`(SQLAlchemy ORM models) and\n`packages/backend/alembic/`(migrations) — the single source of truth for the\nPostgreSQL + pgvector store shared by the backend memory system. Prisma has\nbeen retired (`docs/architecture-analysis/02_design.md` §4.5); SQLAlchemy +\nAlembic own the schema end to end, no second schema definition to keep in\nsync.\n\n## Rules\n\n- 스키마 변경은 항상 `db/models.py`를 먼저 고치고, `pnpm db:revision \"설명\"`으로\n Alembic 리비전을 autogenerate한 뒤 커밋에 함께 포함한다. 수동으로 DB를\n 건드리지 않는다.\n- CHECK 제약조건, 인덱스, partial unique index 등은 마이그레이션 SQL에만 두지\n 않고 `db/models.py", "cost": { "context_tokens": 301 } }

db-sqlalchemy

About

Rules

Verification

Use it

Install db-sqlalchemy and it becomes one more candidate the router can pick - when it fits.

What it costs to adopt - in engineering time.

One base URL

No vendor lock-in

Failover built in

Manifest

Reviews