Database management command syntax

Almost all administration commands have variations. The most common variations include parts of the commands that are optional, or that can have multiple values. Some variations are indicated using special characters. See Reading the administration commands syntax for details.

This page summarizes the various command syntax options. It also includes examples for both Cypher 5 and Cypher 25 when available.

Cypher® versions

The Cypher language has been decoupled from the Neo4j server versioning and now has its own versioning system. You can choose between Cypher 5 and Cypher 25:

  • Cypher 5 is the language version with which all queries written for Neo4j 2025.05 and earlier versions are compatible. It remains the default version for all newly created databases; however, as of Neo4j 2025.06, it is frozen and will only receive performance enhancements and bug fixes in future server releases.

  • Cypher 25 is the new version of the Cypher language. It builds upon Cypher 5 and includes new and improved features, as well as some removals. Any new Cypher features introduced in Neo4j 2025.06 or later will be added only to Cypher 25.

For more information about the Cypher versioning, see Cypher Manual → Select Cypher version.

You can specify the version of Cypher in which you want to run your queries (Cypher 5 or Cypher 25) by configuring a default Cypher version for the whole DBMS, for a database, or by setting it on a per-query basis. For details, see the Configure the Cypher default version.

Reading the administration commands syntax

Table 1. Special characters in syntax summaries
Character Meaning Example

|

Used to indicate alternative parts of a command (i.e. or). Needs to be part of a grouping.

If the syntax needs to specify either a name or *, this can be indicated with * | name.

{ and }

Used to group parts of the command. Commonly found together with |.

In order to use the or in the syntax summary, it needs to be in a group: {* | name}.

[ and ]

Used to indicate an optional part of the command. It also groups alternatives together, when there can be either of the alternatives or nothing.

If a keyword in the syntax can either be in singular or plural, we can indicate that the S is optional with GRAPH[S].

...

Repeated pattern. Related to the command part immediately before this is repeated.

A comma separated list of names would be name[, ...].

"

When a special character is part of the syntax itself, we surround it with " to indicate this.

To include { in the syntax use "{" { * | name } "}". In this case, you will get either { * } or { name }.

The special characters in the table above are the only ones that need to be escaped using " in the syntax summaries.

Here is an example that uses all the special characters. It grants the READ privilege:

GRANT READ
  "{" { * | property[, ...] } "}"
  ON {HOME GRAPH | GRAPH[S] { * | name[, ...] }}
    [ ELEMENT[S] { * | label-or-rel-type[, ...] }
    | NODE[S] { * | label[, ...] }
    | RELATIONSHIP[S] { * | rel-type[, ...] }]
  TO role[, ...]

Note that this command includes { and } in the syntax, and between them there can be a grouping of properties or the character *. It also has multiple optional parts, including the entity part of the command which is the grouping following the graph name. For details about the graph privilege commands syntax, see Components of the graph privilege commands.

However, there is no need to escape any characters when creating a constraint for a node property. This is because ( and ) are not special characters, and [ and ] indicate that the constraint name and the IF NOT EXISTS parts are optional, and therefore not part of the command.

CREATE CONSTRAINT [constraint_name] [IF NOT EXISTS]
FOR (n:LabelName)
REQUIRE n.propertyName IS NOT NULL

Database management command syntax

The database management commands are used to manage standard or composite databases.

Show databases

Command Syntax

SHOW DATABASE

 
SHOW { DATABASE[S] name | DATABASE[S] | DEFAULT DATABASE | HOME DATABASE }
[WHERE expression]
SHOW { DATABASE[S] name | DATABASE[S] | DEFAULT DATABASE | HOME DATABASE }
YIELD { * | field[, ...] } [ORDER BY field[, ...]] [SKIP n] [LIMIT n]
[WHERE expression]
[RETURN field[, ...] [ORDER BY field[, ...]] [SKIP n] [LIMIT n]]

Create a database

Command Syntax

CREATE DATABASE

 
CREATE DATABASE name [IF NOT EXISTS]
[DEFAULT LANGUAGE CYPHER {5|25}]
[TOPOLOGY n PRIMAR{Y|IES} [m SECONDAR{Y|IES}]]
[OPTIONS "{" option: value[, ...] "}"]
[WAIT [n [SEC[OND[S]]]]|NOWAIT]
CREATE OR REPLACE DATABASE name
[DEFAULT LANGUAGE CYPHER {5|25}]
[TOPOLOGY n PRIMAR{Y|IES} [m SECONDAR{Y|IES}]]
[OPTIONS "{" option: value[, ...] "}"]
[WAIT [n [SEC[OND[S]]]]|NOWAIT]

[DEFAULT LANGUAGE CYPHER {5|25}] is available from Neo4j 2025.06 onwards.
Command Syntax

CREATE DATABASE

 
CREATE DATABASE name [IF NOT EXISTS]
[[SET] DEFAULT LANGUAGE CYPHER {5|25}]
[[SET] TOPOLOGY n PRIMAR{Y|IES} [m SECONDAR{Y|IES}]]
[OPTIONS "{" option: value[, ...] "}"]
[WAIT [n [SEC[OND[S]]]]|NOWAIT]
CREATE OR REPLACE DATABASE name
[[SET] DEFAULT LANGUAGE CYPHER {5|25}]
[[SET] TOPOLOGY n PRIMAR{Y|IES} [m SECONDAR{Y|IES}]]
[OPTIONS "{" option: value[, ...] "}"]
[WAIT [n [SEC[OND[S]]]]|NOWAIT]

[[SET] DEFAULT LANGUAGE CYPHER {5|25}] is available from Neo4j 2025.06 onwards.
[TOPOLOGY n PRIMAR{Y\|IES} [m SECONDAR{Y\|IES}]] is replaced by [[SET] TOPOLOGY n PRIMAR{Y\|IES} [m SECONDAR{Y\|IES}]] in Cypher 25.

Create a composite database

Command Syntax

CREATE COMPOSITE DATABASE

 
CREATE COMPOSITE DATABASE name [IF NOT EXISTS]
[DEFAULT LANGUAGE CYPHER {5|25}]
[OPTIONS "{" "}"]
[WAIT [n [SEC[OND[S]]]]|NOWAIT]
CREATE OR REPLACE COMPOSITE DATABASE name
[DEFAULT LANGUAGE CYPHER {5|25}]
[OPTIONS "{" "}"]
[WAIT [n [SEC[OND[S]]]]|NOWAIT]

[DEFAULT LANGUAGE CYPHER {5|25}] is available from Neo4j 2025.06 onwards.
Command Syntax

CREATE COMPOSITE DATABASE

 
CREATE COMPOSITE DATABASE name [IF NOT EXISTS]
[[SET] DEFAULT LANGUAGE CYPHER {5|25}]
[OPTIONS "{" "}"]
[WAIT [n [SEC[OND[S]]]]|NOWAIT]
CREATE OR REPLACE COMPOSITE DATABASE name
[[SET] DEFAULT LANGUAGE CYPHER {5|25}]
[OPTIONS "{" "}"]
[WAIT [n [SEC[OND[S]]]]|NOWAIT]

[[SET] DEFAULT LANGUAGE CYPHER {5|25}] is available from Neo4j 2025.06 onwards.

Alter a database

Command Syntax

ALTER DATABASE

 
ALTER DATABASE name [IF EXISTS]
{
SET ACCESS {READ ONLY | READ WRITE} |
SET TOPOLOGY n PRIMAR{Y|IES} [m SECONDAR{Y|IES}] |
SET OPTION option value |
SET DEFAULT LANGUAGE CYPHER {5|25}
}
[WAIT [n [SEC[OND[S]]]]|NOWAIT]
ALTER DATABASE name [IF EXISTS]
REMOVE OPTION option
[WAIT [n [SEC[OND[S]]]]|NOWAIT]

There can be multiple SET OPTION or REMOVE OPTION clauses for different option keys.

SET DEFAULT LANGUAGE CYPHER {5|25} is available from Neo4j 2025.06 onwards.

Alter a composite database

Command Syntax

ALTER DATABASE

 
ALTER DATABASE name [IF EXISTS]
SET DEFAULT LANGUAGE CYPHER {5|25}
[WAIT [n [SEC[OND[S]]]]|NOWAIT]

Stop a database

Command Syntax

STOP DATABASE

 
STOP DATABASE name [WAIT [n [SEC[OND[S]]]]|NOWAIT]

Start a database

Command Syntax

START DATABASE

 
START DATABASE name [WAIT [n [SEC[OND[S]]]]|NOWAIT]

Delete a database

Command Syntax

DROP DATABASE

 
DROP [COMPOSITE] DATABASE name [IF EXISTS] [RESTRICT | CASCADE ALIAS[ES]] [{DUMP|DESTROY} [DATA]] [WAIT [n [SEC[OND[S]]]]|NOWAIT]

Database alias management command syntax

The database alias management commands are used to manage local or remote database aliases.

Show aliases

Command Syntax

SHOW ALIAS

 
SHOW ALIAS[ES] [name] FOR DATABASE[S]
[WHERE expression]
SHOW ALIAS[ES] [name] FOR DATABASE[S]
YIELD { * | field[, ...] } [ORDER BY field[, ...]] [SKIP n] [LIMIT n]
[WHERE expression]
[RETURN field[, ...] [ORDER BY field[, ...]] [SKIP n] [LIMIT n]]

Lists both local and remote database aliases, optionally filtered on the alias name.

Create a local alias

Command Syntax

CREATE ALIAS

 
CREATE ALIAS name [IF NOT EXISTS] FOR DATABASE targetName
[PROPERTIES "{" key: value[, ...] "}"]
CREATE OR REPLACE ALIAS name FOR DATABASE targetName
[PROPERTIES "{" key: value[, ...] "}"]

Create a remote alias

Command Syntax

CREATE ALIAS

 
CREATE ALIAS name [IF NOT EXISTS] FOR DATABASE targetName
AT 'url' USER username PASSWORD 'password'
[DRIVER "{" setting: value[, ...] "}"]
[DEFAULT LANGUAGE CYPHER {5|25}]
[PROPERTIES "{" key: value[, ...] "}"]
CREATE OR REPLACE ALIAS name FOR DATABASE targetName
AT 'url' USER username PASSWORD 'password'
[DRIVER "{" setting: value[, ...] "}"]
[DEFAULT LANGUAGE CYPHER {5|25}]
[PROPERTIES "{" key: value[, ...] "}"]

[DEFAULT LANGUAGE CYPHER {5|25}] is available from Neo4j 2025.06 onwards.

Alter a local alias

Command Syntax

ALTER ALIAS

 
ALTER ALIAS name [IF EXISTS] SET DATABASE
[TARGET targetName]
[PROPERTIES "{" key: value[, ...] "}"]

Alter a remote alias

Command Syntax

ALTER ALIAS

 
ALTER ALIAS name [IF EXISTS] SET DATABASE
[TARGET targetName AT 'url']
[USER username]
[PASSWORD 'password']
[DRIVER "{" setting: value[, ...] "}"]
[DEFAULT LANGUAGE CYPHER {5|25}]
[PROPERTIES "{" key: value[, ...] "}"]

[DEFAULT LANGUAGE CYPHER {5|25}] is available from Neo4j 2025.06 onwards.

Delete an alias

Command Syntax

DROP ALIAS

 
DROP ALIAS name [IF EXISTS] FOR DATABASE

Drop either a local or remote database alias.