import * as Effect from "effect/Effect";
import * as SqlClient from "effect/sql/SqlClient";
export default Effect.gen(function* () {
const sql = yield* SqlClient.SqlClient;
// Other environments this one signed in to as an outside MCP agent. The
// session token itself is kept in the server secret store under
// `secret_name`, which is unique to each link, so a row always names its
// own token even when two links to one environment race.
yield* sql`
CREATE TABLE IF NOT EXISTS peer_environment_links (
environment_id TEXT PRIMARY KEY,
secret_name TEXT NOT NULL,
label TEXT NOT NULL,
urls_json TEXT NOT NULL,
access TEXT NOT NULL,
linked_at TEXT NOT NULL,
expires_at TEXT NOT NULL,
last_reached_at TEXT,
last_error TEXT
)
`;
});