Apache AGE

Apache AGE 1.8.0 is an open-source graph database extension for PostgreSQL 18 that enables developers and database administrators to store, manage, and query graph and relational data within a single database system.

The solution supports graph-based workflows using the openCypher query language alongside standard SQL. It is suitable for relationship analysis, fraud detection, recommendation systems, network analysis, knowledge graphs, logistics, and other connected-data use cases.

Features of Apache AGE:

• Adds graph database functionality to PostgreSQL.
• Supports openCypher graph queries alongside standard SQL.
• Supports vertices, edges, labels, and graph properties.
• Allows relational and graph data to be managed in one database.
• Supports ACID-compliant PostgreSQL transactions.
• Provides command-line access through the PostgreSQL psql client.

Version Information:

• Apache AGE version: 1.8.0
• PostgreSQL version: 18
• Operating system: Ubuntu 26.04

Usage instructions for Apache AGE:
$ sudo su
$ sudo -u postgres psql -d agedb
agedb=# LOAD 'age';
agedb=# SET search_path = ag_catalog, "$user", public;
agedb=# SELECT create_graph('demo_graph');

Check Apache AGE version:
$ sudo -u postgres psql -d agedb -c "SELECT extname, extversion FROM pg_extension WHERE extname='age';"

Authentication: Local administrative access uses the PostgreSQL operating-system account. Apache AGE does not include a default web username or password.

Access Apache AGE:

Connect through the PostgreSQL command-line client:

sudo -u postgres psql -d agedb

PostgreSQL service port: 5432

Apache AGE does not provide a default web dashboard.

Disclaimer: Apache AGE is provided “as is” under applicable open-source licenses. Users are responsible for secure PostgreSQL configuration, database authentication, network access control, backups, data protection, and validation of graph queries. Port 5432 should not be exposed publicly unless remote database access is properly secured.