Your prompts are always available, even without internet
promptDeck stores everything in a local LibSQL/SQLite database on your machine. Create, edit, and organize prompts while completely offline. When connectivity returns, push your changes to the server and pull updates from your team — conflicts are resolved automatically so you never lose work.
What's included
Offline-first architecture
The desktop app runs against a local LibSQL/SQLite database. Every feature — search, edit, organize, run workflows — works without an internet connection, with zero latency.
Bidirectional push and pull
Push local changes to the server when you are ready, then pull the latest updates from teammates. Sync is explicit, giving you full control over when data travels.
Conflict resolution
When the same record is modified locally and remotely, the newer timestamp wins. This last-write-wins strategy is predictable, transparent, and avoids manual merge dialogs.
Dirty tracking
Every record carries an is_dirty flag. Only changed records are sent during push, minimizing bandwidth and ensuring sync completes in seconds even on slow connections.
ID mapping
Local auto-increment IDs are mapped to server-side UUIDs through a dedicated mapping table. This decouples local and remote identity and prevents collision across devices.
Merge on first login
When you sign in for the first time on a device that already contains local prompts, promptDeck merges — rather than overwrites — your existing library with the server data.
Local-first architecture
The promptDeck desktop app embeds a LibSQL/SQLite database that stores prompts, workflows, categories, variables, and metadata locally. The app never requires an active connection to function. This architecture delivers instant response times, full offline capability, and complete data ownership.
Sync mechanism
Sync is broken into two discrete operations: push and pull. During push, records flagged as dirty are serialized and sent to the server, which responds with server-assigned UUIDs that get stored in the local ID mapping table. During pull, the server returns records updated since the last sync timestamp, and the client upserts them into the local database.
Conflict resolution and data integrity
Conflicts are inevitable when multiple devices edit the same record offline. promptDeck uses a last-write-wins strategy based on the updated_at timestamp. The newer change always takes precedence. This approach avoids complex three-way merges and gives users a clear mental model of how their data evolves.
Stay productive in any environment
Remote and distributed work
Team members in different time zones edit prompts on their own schedule. Changes sync seamlessly when everyone comes online, with no merge conflicts to resolve manually.
Field operations
Use promptDeck in locations with limited or no connectivity — warehouses, factory floors, rural sites. All prompts remain accessible and editable until a network is available.
Travel and commute
Work on prompts during flights, train rides, or anywhere Wi-Fi is spotty. Your entire library is stored locally, so there are no loading spinners or failed requests.
Multi-device workflows
Switch between a desktop at the office and a laptop at home. Push from one device, pull on the other, and pick up exactly where you left off.
Team synchronization
Shared categories sync across all team members. When one person adds a prompt to a shared folder, everyone else receives it on their next pull.
Disaster recovery
Because every device holds a full copy of your data, a server outage never means data loss. Restore from any local database at any time.
Take your prompts everywhere
Download the desktop app and start working offline immediately. Your data syncs automatically when you are back online.