Skip to content
| Marketplace
Sign in
Visual Studio Code>Formatters>CyFormatterNew to Visual Studio Code? Get it now.
CyFormatter

CyFormatter

zhouyu

|
911 installs
| (0) | Free
A Cypher QL Formatter
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Copied to clipboard
More Info

Features

A cypher query language formatter.

Please using Cypher QL extension accompany with this extension.

With a button - Copy Cypher to indent cypher into a single line and copy to clipboard.

Requirements

Install Cypher QL from extension market first, then select Cypher QL as language.

Extension Settings

Use command opt+shift+f to format your document.

Format Result Demo

CALL {
	MATCH (type1:`type1` { fieldName: 'fieldValue', type: 'type1' })
	WITH type1
	MATCH (type1:`type1`)-[:`RELATES_TO` { fieldName: 'a' }]->(type2:`type2` { fieldName: 'fieldValue' })
	WHERE type2.fieldName2 = 'xxxxx'
	RETURN DISTINCT type1
	
	UNION
	
	MATCH (type1:`type1` { fieldName: 'fieldValue', type: 'type1' })
	WITH type1
	MATCH (type1:`type1`)-[:`RELATES_TO` { fieldName: 'dd' }]->(type2:`type2` { fieldName: 'fieldValue' })
	WHERE type2.fieldName2 = 'xxxxx'
	RETURN DISTINCT type1
	
	UNION
	
	MATCH (type1:`type1` { fieldName: 'fieldValue', type: 'type1' })
	WITH type1
	MATCH (type1:`type1`)-[:`RELATES_TO` { fieldName: 'oneName' }]->(type3:`type3` { fieldName: 'fieldValue' })
	WHERE type3.fieldName3 = 'xxxxx'
	RETURN DISTINCT type1
	
	UNION
	
	MATCH (type1:`type1` { fieldName: 'fieldValue', type: 'type1' })
	WITH type1
	MATCH (type1:`type1`)-[:`RELATES_TO` { fieldName: 'xx' }]->(type2:`type2` { fieldName: 'fieldValue' })
	WHERE type2.name = 'xxxxx'
	RETURN DISTINCT type1
	
	UNION
	
	MATCH (type1:`type1` { fieldName: 'fieldValue', type: 'type1' })
	WITH type1
	MATCH (type1:`type1`)-[:`RELATES_TO` { fieldName: 'd' }]->(type2:`type2` { fieldName: 'fieldValue' })
	WHERE type2.name = 'xxxxx'
	RETURN DISTINCT type1 
}
WITH * type1 BY type1.type1Identifier ASC, id(type1) ASC
RETURN type1{ .*, _id: id(type1)} LIMIT 21
MATCH (type1:`type1` {field1: 'value1', type: 'type1'})
WHERE (type1.deleted = false OR type1.deleted IS null )
CALL {
	WITH type1
	MATCH
	(type2:`type2`)-[:`RELATES_TO` {fieldName: 'type3'}]->(type3:`type3`),
	(type2:`type2`)-[:`RELATES_TO` {fieldName: 'type4'}]->(type4:`type4`),
	(type1:`type1`)-[:`RELATES_TO` {fieldName: 'type3'}]->(type3:`type3`),
	(type1)-[:`RELATES_TO` {fieldName: 'type4'}]->(type4:`type4`)
	WHERE type2.startDate = '2022-03-18'
	WITH DISTINCT type2 ORDER BY id(type2) ASC
	CALL {
		WITH type2
		MATCH (type2:`type2`)-[:`RELATES_TO` {fieldName: 'type3'}]->(type3:`type3` {field1: 'value1'})
		WITH DISTINCT type3 ORDER BY id(type3) ASC
		WITH collect(type3{.*, _id: id(type3)})[0..6] AS collectionAlias, count(type3) AS countAlias
		RETURN {dataList: collectionAlias, totalCount: countAlias} AS type2_type3_type3_info 
	}
	CALL {
		WITH type2
		MATCH (type2:`type2`)-[:`RELATES_TO` {fieldName: 'type4'}]->(type4:`type4` {field1: 'value1'})
		WITH DISTINCT type4 ORDER BY id(type4) ASC
		WITH collect(type4{.*, _id: id(type4)})[0..6] AS collectionAlias, count(type4) AS countAlias
		RETURN {dataList: collectionAlias, totalCount: countAlias} AS type2_type4_type4_info 
	}
	WITH collect(type2{.*, _id: id(type2), type3: type2_type3_type3_info, type4: type2_type4_type4_info})[0..6] AS collectionAlias, count(type2) AS countAlias
	RETURN {dataList: collectionAlias, totalCount: countAlias} AS type1_type2_alias2_info 
}
CALL {
	WITH type1
	MATCH
	(type2:`type2`)-[:`RELATES_TO` {fieldName: 'type3'}]->(type3:`type3`),
	(type2:`type2`)-[:`RELATES_TO` {fieldName: 'type4'}]->(type4:`type4`),
	(type1:`type1`)-[:`RELATES_TO` {fieldName: 'type3'}]->(type3:`type3`),
	(type1)-[:`RELATES_TO` {fieldName: 'type4'}]->(type4:`type4`)
	WITH DISTINCT type2 ORDER BY id(type2) ASC
	WITH collect(type2{.*, _id: id(type2)})[0..6] AS collectionAlias, count(type2) AS countAlias
	RETURN {dataList: collectionAlias, totalCount: countAlias} AS type1_type2_alias3_info 
}
RETURN type1{.*, _id: id(type1), `alias2:joinReferences`: type1_type2_alias2_info, `alias3:joinReferences`: type1_type2_alias3_info} LIMIT 6
  • Contact us
  • Jobs
  • Privacy
  • Manage cookies
  • Terms of use
  • Trademarks
© 2025 Microsoft