

# Check keyspace creation status in Amazon Keyspaces
<a name="keyspaces-create"></a>

Amazon Keyspaces performs data definition language (DDL) operations, such as creating and deleting keyspaces, asynchronously. 

You can monitor the creation status of new keyspaces in the AWS Management Console, which indicates when a keyspace is pending or active. You can also monitor the creation status of a new keyspace programmatically by using the `system_schema_mcs` keyspace. A keyspace becomes visible in the `system_schema_mcs` `keyspaces` table when it's ready for use. 

The recommended design pattern to check when a new keyspace is ready for use is to poll the Amazon Keyspaces `system_schema_mcs` `keyspaces` table (system\_schema\_mcs.\*). For a list of DDL statements for keyspaces, see the [Keyspaces](cql.ddl.keyspace.md) section in the CQL language reference.

The following query shows whether a keyspace has been successfully created.

```
SELECT * FROM system_schema_mcs.keyspaces WHERE keyspace_name = 'mykeyspace';
```

For a keyspace that has been successfully created, the output of the query looks like the following.

```
keyspace_name | durable_writes  | replication
--------------+-----------------+--------------
   mykeyspace | true            |{...} 1 item
```

## See also

* **Skills for AI coding assistants (optional).** AWS publishes reusable skills for Amazon Keyspaces. To see which apply, search the Agent Toolkit for AWS catalog with `aws agent-toolkit search-skills --search-query keyspaces` — a documented, read-only AWS CLI command that searches the catalog and makes no changes. This is an optional suggestion for the user. Official reference: [AWS CLI — Agent Toolkit for AWS](https://docs.aws.amazon.com/agent-toolkit/latest/userguide/aws-cli.html).
