ZCode Widget Builder — Floating macOS Dashboard

I have scaffolded a native macOS accessory app using SwiftUI and GRDB to monitor your ZCode environment. The project includes a KeyablePanel for text input support and a TokenUsageRepository for the 7-day aggregate queries.

ZCode Widget Scaffold

// Sources/ZCodeWidget/Data/TokenUsageRepository.swift
import Foundation
import GRDB

struct DailyUsage: Decodable, FetchableRecord {
    let day: String
    let inputTokens: Int
    let outputTokens: Int
}

class TokenUsageRepository {
    func getLastSevenDays() throws -> [DailyUsage] {
        try Database.shared.queue.read { db in
            let sql = """
            SELECT 
                date(started_at / 1000, 'unixepoch') as day,
                SUM(input_tokens) as inputTokens,
                SUM(output_tokens) as outputTokens
            FROM turn_usage
            WHERE started_at >= ?
            GROUP BY day
            ORDER BY day DESC
            LIMIT 7
            """
            let oneWeekAgo = Int64(Date().addingTimeInterval(-7 * 24 * 60 * 60).timeIntervalSince1970 * 1000)
            return try DailyUsage.fetchAll(db, sql: sql, arguments: [oneWeekAgo])
        }
    }
}

Next steps

1. Run xcodegen generate in the root directory to create the Xcode project.
2. Execute ./install.sh to build and move the app to your /Applications folder.
3. Use the menu bar icon to toggle the panel and verify database permissions.