AgensGraph

AgensGraph

Powerful Multi-Model Graph Database
Developer(s)	SKAI Worldwide
Initial release	16 January 2017 (2017-01-16)
Stable release	2.15.0
Repository	github.com/skaiworldwide-oss/agensgraph
Written in	C
Engine
Operating system	Cross-platform
Type	Graph database
License	Apache License 2.0
Website	skaiworldwide.comproduct/dbms/agens_graph/

Search AgensGraph on Amazon.

AgensGraph is an open-source graph database developed by SKAI Worldwide (former Bitnine), a South Korean company specializing in graph database solutions. AgensGraph is PostgreSQL-derived database. It combines RDB and GDB features and support all the extension which are supported by PostgreSQL.

Version 1.0.0 was released in January 2017.

From 2017 onwards, AgensGraph community has consistently released new versions with enhancements. These updates included performance improvements, new features (like query language extensions), and better integration with other tools.

Latest community version of AgensGraph is v2.15.0 which was released in April 2025.

AgensGraph Community Edition is released under the Apache 2 License. The Enterprise Edition requires a commercial license.

Features

AgensGraph uniquely blends SQL and Cypher queries, enabling seamless interaction with both relational and graph data in a single query.

• It supports a multi-model approach, handling property graphs, relational data, and JSON documents, simplifying diverse data management.

• Hierarchical label organization via "Label Inheritance" structures large graph datasets efficiently.

• Property indexing on vertices and edges ensures fast queries, while constraints maintain data integrity.

• It supports relational and graph data triggers.

• ACID transactions guarantee data reliability.

• It support SQL syntax, Cypher syntax and also hybrid of both queries.

Storage and Data Structure

AgensGraph's fundamental graph components are nodes, edges that establish connections between nodes, and the properties that characterize each node and edge.

AgensGraph utilizes relational tables to persist graph data. Each node and edge type is represented by a dedicated table. Dynamic node properties are handled through JSON object storage, and B-tree indexes are automatically generated to optimize query performance.

Query Syntax

AgensGraph boasts comprehensive support for two powerful query languages: SQL and Cypher. This dual-language capability allows users to leverage the strengths of both relational and graph database paradigms.

For relational data manipulation, AgensGraph adheres to standard SQL syntax, ensuring compatibility with existing applications and tools. When navigating complex relationships and patterns within graph data, users can seamlessly switch to Cypher, a declarative graph query language designed for intuitive and efficient traversal.

SELECT p.first_name, p.last_name, ct.name
FROM person p, city c
WHERE nationality(c.name) = 'EU'

AgensGraph's Cypher implementation aligns closely with the openCypher specification, facilitating interoperability and ease of use for developers familiar with other graph databases.

MATCH (p:Person)-[:LIVES_IN]->(c:City), (p:Person)-[:NATIONAL_OF]->(EUCountry)
RETURN p.first_name, p.last_name, c.name, c.state

In AgensGraph you can also write hybrid queries to increase performance, better data integration. There are two ways to write hybrid queries.

1. Cypher in SQL

SELECT p.first_name, p.last_name, ct.name
FROM city c,(MATCH (p:Person) RETURN p) as person, 
WHERE nationality(c.name) = 'EU'

2. SQL in Cypher

MATCH (p:Person)
WHERE p.city IN (SELECT city FROM countries WHERE nationality(city) = 'EU')
RETURN properties(p) AS p;

Both ISO standards GQL and SQL/PGQ (Published in 2023 and 2024 respectively) support hybrid query syntax which combines graph and relational model.

Performance

In term of transaction processing, complex aggregate queries and data import, AgensGraph is 3x to 25x faster than ArangoDB and OrientDB.

Because AgensGraph is derived from PostgreSQL, its performance can be improved with PostgreSQL performance recommendation and using Graph Property Index.

Release history

Release history

Release	First release	Latest minor version	Latest release	End of Support Date
1.0	2017-01-16	Old version, no longer supported: 1.0.0	N/A	2020-01-16
1.1	2017-03-16	Old version, no longer supported: 1.1.0	N/A	2021-11-11
1.2	2017-08-22	Old version, no longer supported: 1.2.1	2018-08-21	2021-11-11
1.3	2017-12-14	Old version, no longer supported: 1.3.2	2018-09-06	2022-11-10
2.0	2018-09-18	Old version, no longer supported: 2.0.0	N/A	2022-11-10
2.1	2019-01-17	Old version, no longer supported: 2.1.3	2020-01-14	2022-11-10
2.5	2021-10-06	Old version, no longer supported: 2.5.0	N/A	2023-11-09
2.12	2022-01-08	Old version, no longer supported: 2.12.1	2023-01-11	2024-11-21
2.13	2022-11-10	Older version, yet still supported: 2.13.1	2023-01-11	2025-11-13
2.14	2025-01-16	Older version, yet still supported: 2.14.1	N/A	2026-11-12
2.15	2025-04-04	Current stable version: 2.15.0	N/A	2027-11-11

Legend:

Old version

Older version, still supported

Latest version

Latest preview version

Future release

Related project

Because of Graph database popularity, An AgensGraph extension was proposed to The Apache Software Foundation. Proposal was accepted and moved to incubation in April 2020.

After two more years of development in June 2022 Apache® announced Apache AGE Template:TM as Top Level Project as graph extension for PostgreSQL database.

See also

• Graph Query Language (GQL)
• Cypher (query language)

External links

• Official website
• agensgraph on GitHub

This article "AgensGraph" is from Wikipedia. The list of its authors can be seen in its historical and/or the page Edithistory:AgensGraph. Articles copied from Draft Namespace on Wikipedia could be seen on the Draft Namespace of Wikipedia and not main one.

📰 Article(s) of the same category(ies)

• HomerHEVC
• Microsoft Reflect
• Clutter (software)
• NL5 Circuit Simulator
• GuardianKey
• Sobi2
• Bareos

---