What Bolt Database includes
- Unlimited databases: You can create as many projects with a database as you want.
- No manual setup: You don’t configure servers or hosting. Bolt handles it for you.
- Authentication settings: Manage sign-in options for your app.
- One place for monitoring: Keep track of security and logs without switching tools.
Creating and using databases
Bolt creates a database when your project needs one, or when you ask Bolt for a database or a feature that uses one. For example, if you create a trivia app, Bolt sets up a database to store questions and answers.Ask Bolt not to create a database
If you don’t want Bolt to create a database, add this to your prompt. For example:Add login and sign-up to your app
To let people create accounts in your app, ask Bolt to add sign-up and login. For example:Manage your Bolt Database
To open your database settings, click the database icon in the top center of your screen.
Data and files
- Tables: View and manage the rows in your tables. You can add, filter, query, delete, and export row data.
- File storage: View your file storage buckets and check which are public or private. This page also lists the file types Bolt supports.
- User management: View the users who signed up for your app, invite users by email, or add them manually.
Sign-in and email
- Authentication: Set up email and Google sign-in, and configure password reset and email templates.
- Send emails from your app: Send transactional and authentication emails by connecting an email provider.
Backend and credentials
- Server functions: View your server functions and their logs, and delete the ones you no longer need.
- Secrets: Manage the keys, passwords, and other credentials that Bolt needs to connect your project to outside services.
Monitoring and security
- Logs: Monitor and debug your app with logs for server functions, authentication, PostgreSQL, storage, and more.
- Security Audit: Check your database for security issues, such as an open permission or a missing RLS policy, and ask Bolt to fix what it finds. The audit checks only your database.
Advanced settings
- Advanced settings: Restart an unresponsive database, connect to Supabase instead, or claim your database into your own Supabase account.
Automatically paused databases
If your Bolt Database has low usage for six days or more, Bolt can 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. When you open a project with a paused database, Bolt restores the database and shows this message:Restoring your paused database. Your Bolt Database is paused due to inactivity and is now being restored. This may take a few minutes. After the database is restored, you can continue building your project.
To keep your database from being paused, publish your project with Bolt hosting. Databases in live Bolt-hosted projects aren’t paused for inactivity. Unpublished projects and projects published with Netlify hosting can be paused. If your project uses Netlify hosting, you can switch to Bolt hosting.
If your project uses a Supabase database, whether you claimed it from Bolt or connected it, your Supabase plan’s rules apply instead. On Supabase’s Free plan, Supabase pauses databases after a week of low activity, even if your Bolt project is published. To resume a paused Supabase database, see My Supabase database looks disconnected in Bolt.
View Bolt Database limits
Your database limits are on the Cloud settings page. For individual accounts, Cloud is under your Account settings. For Teams accounts, it’s under your team’s workspace settings.
- On the Bolt homepage, in the sidebar, click your account or workspace name, then click Settings (gear icon).
- Click Cloud.
- Review the database-related rows in the table.
Use Supabase instead of Bolt Database
Bolt Database works for most projects. If you have a Pro or Teams plan and need features like SQL editing or advanced monitoring in the Supabase dashboard, you can use a database in your own Supabase account instead. To compare the options, see Decide whether to use Supabase.- For a new project: Select Supabase when you start the project.
- For a project that already has a Bolt Database: Claim your Bolt Database in Supabase to move it and its data to your Supabase account.
Troubleshooting
- Bolt Database troubleshooting: See Database issues for help if your database isn’t responding or if Bolt shows an error when trying to access table data.
- Supabase troubleshooting: See Supabase integration FAQs and troubleshooting for help with connection issues.