Writers Room Greenlight

• 

  Writers Room Greenlight

Inspiration

Love screenplays, and I find them extremely entertaining as a read. I would like to help Screenwriters craft with a sharp tool for productivity

What it does

A single-process AI writer's room that converts Fountain/FDX screenplay drafts into structured story bibles, real-time analytics, automated rewrites, and multi-character audio table reads.

How we built it

By trial and error, always thinking about it as a tool to help the craft

ClickHouse Cloud (Sole State Store) Over 20+ specialized tables manage immutable screenplay versions (ReplacingMergeTree), story bible facts, agent_runs history, scene statistics, and content-addressed TTS caches.
Zero data sprawl. Eliminates the need for separate Redis caches or secondary Postgres databases while enabling instant analytical queries over millions of script tokens. ClickHouse-Powered Agent Tools. The Analytics Agent executes bound-parameter SQL directly against ClickHouse to inspect scene pacing, character line shares, and structural breakdown math. Real-time structured analytical queries delivered instantly to the LLM without manual preprocessing. Grafana Observability Suite Live Grafana dashboards visualize agent execution latency, token throughput across Gemini models, ClickHouse query speed, and tts_turn_cache hit ratios. Instant visibility into system bottlenecks, LLM response times, and state transitions during multi-agent orchestration.

Challenges we ran into

A lot. Polishing the idea into product, arquitecture, DBs, how we integrate sponsors, understand sponsor services, lots of bugs. Database mess...

Accomplishments that we're proud of

I finally decided to enter a devpost hackathon, and finish it. Not sure what to expect of it. but im proud of the product

What we learned

Hackathons are for quick learners

What's next for Writers Room Greenlight

Hopefully someone is interested. I would love to make it a long time commitment, and I also have a couple of spinoff ideas.

Built With

• clickhouse
• clickhouse-cloud
• cloud-run
• docker
• emotion-style
• fastapi
• firebase
• firebase-hosting
• gemini-3.1-flash-tts-preview
• gemini-models
• google-adk
• google-cloud
• google-genai
• grafana
• grafana-cloud
• oxlint
• pydantic
• python
• react
• react-router
• vite-8
• wavesurfer.js
• zustand