---
title: "POST /v1/projects/{project}/instances/{instance}/databases"
method: POST
path: "/v1/projects/{project}/instances/{instance}/databases"
tags: ["databases"]
---

# POST /v1/projects/{project}/instances/{instance}/databases

`POST /v1/projects/{project}/instances/{instance}/databases`

Inserts a resource containing information about a database inside a Cloud SQL instance. **Note:** You can't modify the default character set and collation.

## Path parameters

- `project` string, required
- `instance` string, required

## Request body

- Database — Represents a SQL database on the Cloud SQL instance.
  - `name` string — The name of the database in the Cloud SQL instance. This does not include the project ID or instance name.
  - `sqlserverDatabaseDetails` SqlServerDatabaseDetails — Represents a Sql Server database on the Cloud SQL instance.
    - `recoveryModel` string — The recovery model of a SQL Server database
    - `compatibilityLevel` integer — The version of SQL Server with which the database is to be made compatible
  - `etag` string — This field is deprecated and will be removed from a future version of the API.
  - `kind` string — This is always `sql#database`.
  - `selfLink` string — The URI of this resource.
  - `instance` string — The name of the Cloud SQL instance. This does not include the project ID.
  - `charset` string — The Cloud SQL charset value.
  - `collation` string — The Cloud SQL collation value.
  - `project` string — The project ID of the project containing the Cloud SQL database. The Google apps domain is prefixed if applicable.

## Response `200`

Successful response

---

[API](https://skmtc.net/google/apis/sqladmin.md) · [All operations](https://skmtc.net/google/apis/sqladmin/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/google/sqladmin/versions/e9eef8a2afcd/schema)