Château Tire-Bouchon
Château Tire-Bouchon is a wine estate in the Basque Country (AOP Irouléguy) that does not exist. I built it to show what software for a physical business can look like: a 3D map of the estate where everything moves with the data, and the full back-office behind it, on one Supabase database.
Open the demo and you get your own private copy of the estate, with no account. Every company, name and figure in it is made up. Integrations that would reach the outside world run in simulated mode, and the screen says so.
The challenge
Most management software looks the same: lists, forms, tabs. It does the job, but you never see the business. For a trade that happens in one place, like a wine cellar, a workshop or a depot, I wanted to start from the place.
An estate like this one usually runs on tools that don't talk to each other. Orders, stock and schedules live in separate spreadsheets. Corks and labels run out before anyone notices. Seasonal pickers come and go with their hours, contracts and badges. And nobody sees the whole day at once: who is in, what ships today, which tank needs a look.
The solution
The map is a view on the same tables as the back-office. When an order moves on the kanban, its parcel moves on the map. When an employee badges out for a break, their character walks to the pelota wall. Click any object and its card opens, with a link to the full back-office screen.
The back-office covers the rest of the trade: CRM, quotes and orders, stock, operations, HR (badges, leave, timesheets, salaries), finance with Factur-X invoices (not yet checked by an official Factur-X validator) and the FEC export, messaging, an AI assistant and automations.
Permissions live in the database. Every table has Row Level Security, and writes go through SQL functions that check the right, apply the business rule and log the event in one transaction. A badly coded screen cannot get around a right. Salaries sit in their own table that only management and HR can read. The 3D scene is React Three Fiber with procedural geometry: no model files, every building, tank and character comes from simple shapes.
I wrote the spec, split the work into phases, and reviewed and tested every step. AI coding agents wrote the code.
Results
These figures come from the repository, counted on 10 November 2026: 30 SQL migrations you can replay, 70 Postgres tables, 238 RLS policies and 312 automated tests in Vitest and Playwright. On a desktop GPU (an RTX 4070 Super, Chromium at 1440 × 900), the map runs at 60 frames per second.
This is a demo, not a client project. It proves the build and the method, not a business result. The demo is live: sign a quote, move an order, reveal a salary, and the next visitor still gets a clean estate. The full case study is in French.
Key features
- 01A live 3D map: every object is clickable, and the data drives every animation
- 02The full back-office on the same database: CRM, orders, stock, HR, finance
- 03Permissions held by 238 RLS policies in Postgres, not by the screen
- 04A public demo with no account: each visitor gets a private copy of the estate
Gallery
Available for a new mission
Your app, faster with AI, and still yours.
Over two and a half years leading Odisei Play: one codebase on iOS, Android and web, a release every two weeks, with two developers, a designer and AI agents. That role on your team, or the AI setup that makes the pace possible.