Add Existing Database


  • For MongoDB/Postgres/SQLServer users: Space Cloud connects to the database with the name of your project id in case of MongoDB and SQL Server. In case of Postgres, it connects to the schema with the name of your project id inside the specified database. This behaviour will be fixed in an upcoming release. So as of now if you want to use your existing database/schema, you should name your project with the name of your database/schema. If you already have a project, then you should recreate the project with the database/schema name or rename the database/schema.
  • For MySQL users: You can connect space cloud to any existing database. However, you need to start space cloud with the --remove-project-flag. If you are using space-cli then you can use the following command to start space cloud - space-cli setup --env REMOVE_PROJECT_SCOPE.


You need to follow some steps before adding an existing database based on where your existing database is:

Inside single node docker (started by space cli)

  • For MySQL users: You need to start space cloud with the --remove-project-flag. If you are using space-cli then you can use the following command to start space cloud - space-cli setup --env REMOVE_PROJECT_SCOPE.
  • For MongoDB/Postgres/SQLServer users: No need to start space cloud with any special flags.

The databases started with space cli have fixed hostname of the following format:


For example, if you have kept the DB alias name of your database as mydb while spinning up the database via space-cli, then your hostname will be:


Note down this hostname as it will be used while adding the database to Space Cloud.

Inside single node docker (started manually by you)

If you have run Space Cloud via space-cli but have an existing database (inside a docker container) not started by space-cli, then you need to follow these extra steps.

Connect you database to Space Cloud’s network by running the following command:

docker network connect space-cloud <your-database-container-name>

For example, if your database container name is some-mongo, then you need to run:

docker network connect space-cloud some-mongo

Inspect your database container to get its IP Address. Run the following command:

docker inspect <your-database-container-name>

It will log a very big JSON object on the console. The IPAdrress you are interested in will be under key. This is the IP Adrress that will be used as the hostname while adding the database.

Inside Kubernetes

Make sure you have created a Kubernetes service for your database inside a particular namespace.

The namespace containing your database service should be different from your space cloud project id.

The hostname of your database for Space Cloud would then be:


For example, if you have created a service named my-postgres inside my-databases namespace, then your hostname will be:

Note down the hostname as it will be required later while adding the database to Space Cloud.

Outside (Managed service)

If you are using one of the managed services like AWS RDS, Google Cloud SQL, etc. you need to get the hostname of the database from the console of that managed database.

Adding a database to Space Cloud

Head to the Mission Control. If you have not already created your project, first create your project:

Create project screen

While creating a project, you will be prompted to add a database to your project with the following screen:

Add database screen

Note: You can also add database(s) later to your project. To add a database to your project, you need to go the Database section of that project, click on the database selector/dropdown and then click on the Add database button to open the screen to add a database.

First, select a particular database that you want to add.

Then, provide the connection string of that selected database. The connection string is of the following format for the various databases:

Data Source=<host>,1433;Initial Catalog=master;User ID=<username>;Password=<password>@#;

Use the hostname collected from the prerequisite step in the above connection string format.

Then, give your database an alias name. The alias name that you provide here should be used in your GraphQL queries to identify your database (since Space Cloud can work with multiple databases). By default alias name is mongo, postgres, mysql and sqlserver for MongoDB, Postgres, MySQL and SQL Server respectively.

For example, if you change the alias name to mydb, then your GraphQL queries should be updated to include mydb like this:

query {
  pokemon @mydb {

Finally, click on the Add database button. That’s it! You have added your existing database to Space Cloud! You can now start tracking your existing tables/collection or create new ones.

Tracking existing tables

Tracking a table/collection in Space Cloud exposes that table/collection via its GraphQL/REST APIs to the outside world (with security rules of course).

New tables created via Mission Control are automatically tracked. However, existing tables need to be explicitly tracked if you want to expose them via Space Cloud’s GraphQL/REST APIs.

To track existing tables, head to the Overview tab of Database section in Mission Control. If you have any existing tables in your database that haven’t been tracked yet, you will see them under Untracked Tables like these:

Untracked tables

Click on the Track button beside the table name that you want to track. If you want to track all tables/collections, then click on the Track all button.

You don’t need to provide a schema while tracking tables in SQL databases as Space Cloud understands it automatically by inspecting the database. However, in the case of schemaless databases such as MongoDB, you need to edit the table after it is tracked to provide a schema.

Tracking indexes

Space Cloud automatically detects and tracks any primary/foreign keys when you track a table. However, as of now, indexes are only tracked if the index name starts with index.

There are 2 workarounds this problem:

  • Drop the index directly from the database shell and create the index once again through Mission Control.
  • Rename the index directly from the database shell before tracking the table so that the index name starts with index.

The following SQL query can be used to rename an index:

ALTER INDEX <index-name> RENAME TO <new-index-name>;
ALTER TABLE <table-name> RENAME INDEX <index-name> TO <new-index-name>;
EXEC sp_rename N'<schema-name>.<table-name>.<index-name>', N'<new-index-name>', N'INDEX';

That’s it you can now start various operations on your existing data like:

Have a technical question?

Improve the docs!