import { Sqlite } from "smithers-orchestrator";

<Claude model="sonnet" maxTurns={10}>
  <Sqlite path="./data.db" readOnly>
    Database schema:
    - users(id, name, email)
    - orders(id, user_id, total)
  </Sqlite>

  Find users who have placed orders over $100.
</Claude>

<Sqlite path="./production.db" readOnly>
  Production data - read only access.
</Sqlite>

<Claude model="sonnet" maxTurns={15}>
  <Sqlite path="./users.db">User database</Sqlite>
  <Sqlite path="./analytics.db">Analytics database</Sqlite>

  Cross-reference user signups with analytics events.
</Claude>

<Claude
  tools={[
    {
      name: "query_database",
      description: "Query the PostgreSQL database",
      inputSchema: {
        type: "object",
        properties: {
          query: { type: "string", description: "SQL query to execute" },
        },
        required: ["query"],
      },
      execute: async (input, context) => {
        const result = await db.query(input.query);
        return JSON.stringify(result);
      },
    },
  ]}
>
  Query the database for user statistics.
</Claude>

import { useQueryValue } from "smithers-orchestrator/reactive-sqlite";

function DataPipeline() {
  const { db, reactiveDb } = useSmithers();

  const phase = useQueryValue<string>(
    reactiveDb,
    "SELECT value FROM state WHERE key = 'phase'"
  ) ?? "query";

  const data = useQueryValue<string>(
    reactiveDb,
    "SELECT value FROM state WHERE key = 'data'"
  );

  const setPhase = (newPhase: string) => {
    db.state.set("phase", newPhase);
  };

  return (
    <SmithersProvider db={db} executionId={executionId} maxIterations={5}>
      <If condition={phase === "query"}>
        <Claude
          model="sonnet"
          onFinished={(result) => {
            db.state.set("data", result.output);
            setPhase("analyze");
          }}
        >
          <Sqlite path="./sales.db" readOnly>
            Sales database with orders and products.
          </Sqlite>

          Query the top 10 products by revenue.
        </Claude>
      </If>

      <If condition={phase === "analyze"}>
        <Claude
          model="sonnet"
          allowedTools={["Write"]}
          onFinished={() => setPhase("done")}
        >
          Analyze this data and write a report:
          {data}

          Save to reports/sales-analysis.md
        </Claude>
      </If>
    </SmithersProvider>
  );
}

<Claude model="sonnet" maxTurns={10} allowedTools={["Write"]}>
  <Sqlite path="./analytics.db" readOnly>
    Event tracking database.
  </Sqlite>

  Generate a CSV export of daily active users.
  Save to exports/dau.csv
</Claude>

// Safe - read only
<Sqlite path="./prod.db" readOnly>...</Sqlite>

// Risky - allows writes
<Sqlite path="./prod.db">...</Sqlite>

<Claude
  allowedTools={["query_database"]}  // Only database access
  disallowedTools={["Bash"]}         // No shell commands
>
  <Sqlite path="./data.db" readOnly>
    Schema here.
  </Sqlite>

  Analyze the data (no shell commands needed).
</Claude>