Database settings

- Advanced settings
- Authentication
- File Storage
- Logs
- Secrets
- Security Audit
- Server Functions
- Tables
- User Management
- FAQs
Benefits of Bolt Database
Using a Bolt database helps you get more complicated web apps up and running quickly:- Unlimited databases: Create as many databases as needed.
- No manual setup: Skip configuring servers or hosting. Bolt handles it for you.
- Built-in authentication management: Easily add user sign-up capabilities to your project.
- One place for monitoring: Keep track of security and logs without switching tools.
- Future-proof connections: Easily connect external tools later for advanced control.
If you’re new to the concept of databases and their importance in web development, you can learn more in our Introduction to databases article.
Creating and using databases
Bolt creates a database automatically if your project needs one, or if you explicitly ask Bolt to create a database or a database-related feature. This makes it easy to get started without manually setting anything up.Ask Bolt not to create a database
If you don’t want Bolt to provision a database, you can explicitly request that it not do so. For example, when submitting a prompt, add the instruction:Don't use a database, I want to use local storage for this app.
Use Supabase instead of Bolt database
If you prefer to use Supabase when creating a new project, you can select it during setup.See Start a project using Supabase to learn more.
Version history and database restores
Restoring to an earlier project version will not change your current databases.Automatically paused databases
In unpublished projects, if your database has low usage for six days or more, Bolt may automatically pause it to conserve resources. In most cases, a few user requests to the database each day is enough activity to keep the database from being paused. If your database is paused, you’ll see the following message the next time you open your project:Restoring your paused database. Your Bolt Database is paused due to inactivity and is now being restored. This may take a few minutes.
This is a routine process. After the database is restored, you can continue building your project.
If you’ve published your project to a live site, your database won’t be paused. Automatic pausing only happens in unpublished projects.
View Bolt Database limits
You can view database-related limits on the Cloud settings page. Your Cloud settings appear in a different location depending on your plan. For individual accounts, Cloud is under your Account settings. For Teams accounts, it’s under your team’s workspace settings.
- Click your profile icon in the top left of your screen, then click Settings.
- Click Cloud.
- Review the database-related rows in the table.
How Bolt provisions a database
When you create a project, Bolt can automatically create a database if your app requires one or if you explicitly request it. For example, if you create a trivia app, Bolt will set up a database to store questions and answers. Features like user authentication may not be added automatically, but you can prompt Bolt to include sign-up and log-in if your app requires them. For example:Create user accounts via email signup and login, then add account sign in/log out buttons in the top right corner of the home page.