The best way to control Claude Code, Codex and more from any computer or phone

main
ts 54 lines 1.42 KB
Raw
1 import * as Effect from "effect/Effect";
2 import * as SqlClient from "effect/sql/SqlClient";
3
4 /** Role-bearing credentials and sessions cannot safely receive new capabilities implicitly. */
5 export default Effect.gen(function* () {
6 const sql = yield* SqlClient.SqlClient;
7
8 yield* sql`DROP TABLE IF EXISTS auth_pairing_links`;
9 yield* sql`DROP TABLE IF EXISTS auth_sessions`;
10
11 yield* sql`
12 CREATE TABLE auth_pairing_links (
13 id TEXT PRIMARY KEY,
14 credential TEXT NOT NULL UNIQUE,
15 method TEXT NOT NULL,
16 scopes TEXT NOT NULL,
17 subject TEXT NOT NULL,
18 label TEXT,
19 created_at TEXT NOT NULL,
20 expires_at TEXT NOT NULL,
21 consumed_at TEXT,
22 revoked_at TEXT
23 )
24 `;
25
26 yield* sql`
27 CREATE INDEX idx_auth_pairing_links_active
28 ON auth_pairing_links(revoked_at, consumed_at, expires_at)
29 `;
30
31 yield* sql`
32 CREATE TABLE auth_sessions (
33 session_id TEXT PRIMARY KEY,
34 subject TEXT NOT NULL,
35 scopes TEXT NOT NULL,
36 method TEXT NOT NULL,
37 client_label TEXT,
38 client_ip_address TEXT,
39 client_user_agent TEXT,
40 client_device_type TEXT NOT NULL DEFAULT 'unknown',
41 client_os TEXT,
42 client_browser TEXT,
43 issued_at TEXT NOT NULL,
44 expires_at TEXT NOT NULL,
45 last_connected_at TEXT,
46 revoked_at TEXT
47 )
48 `;
49
50 yield* sql`
51 CREATE INDEX idx_auth_sessions_active
52 ON auth_sessions(revoked_at, expires_at, issued_at)
53 `;
54 });