How to find namespace and database name for newly created surrealdb?

[0xBradock]

Hello,

I am trying to connect for the first time using the surrealist app but I don't know the initial namespace and database name.

• I installed surrealdb in an EC2 with curl -sSf https://install.surrealdb.com | sh
• Started the db with surreal start --log trace --user <user> --pass <pass> file:<file>.db
• In my browser, if I navigate to the public DNS:8000 I am redirected to the surrealist page

Then, to connect with surrealist I need a namespace and database, but I can not find info on this.
If I try to connect with a random namespace and random database name I get the following error:

Any help is appreciated,

[matthewjnield]

Hello @0xBradock, here are some tips that are helpful for when you are in a SurrealDB instance and don't know what namespaces and databases exist, or which namespace and database is the one that is currently active in your session. All of these should work when run as a query either from the CLI tool or Surrealist.

If you don't know what namespaces and databases exist in your SurrealDB session:

The INFO statement can return information about your SurrealDB session, including the namespaces and databases that exist.

You can get information about the overall SurrealDB session, including a list of all namespaces that exist, with the INFO statement. I believe these two are equivalent:

INFO FOR ROOT;
INFO FOR KV;

You can set a given namespace as active with the USE statement:

USE NAMESPACE existing_namespace_name;

You can see what databases exist in the current namespace with this INFO statement:

INFO FOR NAMESPACE;

You can set a given database as active with the USE statement:

USE DATABASE existing_database_name;

If you know what namespaces and databases exist in your SurrealDB session, but don't know which are currently active:

The session::ns() function will return a string with the name of the namespace that is currently active in your session.

RETURN session::ns();

The session::db() function will return a string with the name of the database that is currently active in your session.

RETURN session::db();

If no namespaces and/or databases exist in your SurrealDB session:

The USE statement will create the namespace or database that you specify if it does not already exist.

USE NAMESPACE new_namespace_name;
USE DATABASE new_database_name;

Sources

https://surrealdb.com/docs/surrealql/statements/info
https://surrealdb.com/docs/surrealql/statements/use
https://surrealdb.com/docs/surrealql/functions/database/session