• Get SurrealDB connection (cached singleton pattern)

    Returns a cached connection if available, otherwise creates a new one. The connection is configured for the Generic Hierarchical Embedder (GHE) database.

    Database structure:

    • Namespace: "tidyscripts"
    • Database: "GHE"

    Returns Promise<Surreal>

    Connected Surreal instance

    Error if connection fails or configuration is invalid

    const db = await get_database();
    const result = await db.query('SELECT * FROM project');