# @memo-labs/database

Database clients, Prisma schema and persistence helpers for memo.

This package is primarily used by the SDK, API service and workers. Application code usually does not need to import it directly.

## Responsibilities

- Prisma schema and generated client.
- PostgreSQL access for Full mode.
- SQLite-related database setup used by Standalone paths.
- Redis schema helpers where needed by queue and cache integrations.

## Common Commands

```bash
pnpm --filter @memo-labs/database db:generate
pnpm --filter @memo-labs/database db:migrate
pnpm --filter @memo-labs/database db:seed
pnpm --filter @memo-labs/database db:studio
```

## Usage

```typescript
import { getPrismaClient } from "@memo-labs/database";

const prisma = getPrismaClient();
const sessions = await prisma.session.findMany({
  where: { userId: "user-123" },
});
```

## Development Notes

- Keep schema changes backward-aware while the project is in v0.x.
- Prefer migrations over ad hoc database changes.
- Do not expose database implementation details through public SDK APIs.

## Test

```bash
pnpm --filter @memo-labs/database test
```