> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Reference and syntax for the CREATE DATABASE command.

# CREATE DATABASE

Creates a new database.

<Note>
  Each account supports up to 100 databases. If you need more, contact Firebolt's support team at [support@firebolt.io](mailto:support@firebolt.io).
</Note>

## Syntax

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
CREATE DATABASE [IF NOT EXISTS] <database_name>
[ WITH 
[ DESCRIPTION = <description> ]
]
```

## Parameters

| Parameter                     | Description                                                                   |
| :---------------------------- | :---------------------------------------------------------------------------- |
| `<database_name>`             | The name of the database.                                                     |
| `DESCRIPTION = 'description'` | (Optional) The database's description, which can contain up to 64 characters. |

## Example

The following code example creates a database named `my_db` with an optional description, `Testing database`:

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
CREATE DATABASE IF NOT EXISTS my_db
WITH DESCRIPTION = 'Testing database'
```

## See also

To mount an external Iceberg catalog as a Firebolt database whose tables are resolved against the upstream catalog at query time, see [`CREATE ICEBERG DATABASE`](/reference-sql/commands/data-definition/create-iceberg-database).