How do I delete a database in Neon?

Open your project in the Neon Console, go to Databases, select the branch, and click the delete icon on the database row. You can also delete a database with the Neon CLI, the API, or SQL (DROP DATABASE). Deletion is permanent. All schemas, tables, indexes, and other objects in the database are dropped along with it. See Delete a database for the full reference.

Delete a database

Sign in to the Neon Console and select your project.
Click Databases in the sidebar.
Select the branch containing the database.
For the database you want to delete, click the delete icon.
In the confirmation dialog, click Delete.

What gets removed

Dropping a database removes all SQL objects inside it: schemas, tables, indexes, views, materialized views, functions, sequences, and any data. Roles aren't deleted; they live at the branch level and may own objects in other databases. The storage the database consumed stops counting against your project's storage usage once the drop completes.

The branch, compute, and any other databases on the branch aren't affected.

Deletion is permanent

There's no undo on DROP DATABASE. If your project's history window still covers the moment before the drop, you can recover with instant restore on the root branch, which restores every database on that branch to the chosen point in time. Outside the history window (6 hours on Free, up to 7 or 30 days on paid plans), the only recovery path is your own backups.

Delete the whole project instead

If you want to remove everything (every database, branch, snapshot, and the project itself), go to Project settings > General > Delete project. That action is also permanent and stops all billing for the project. See Manage projects.