Ontop
ontop-vkg.org
- Free plan
- Windows
- macOS
- Linux
- Web
- API
- Self-hosted
What Ontop is
Ontop is an open-source Virtual Knowledge Graph system that lets users query relational database content as knowledge graphs without moving the data from its source databases. It translates SPARQL queries into SQL for execution by connected data sources. Ontop uses RDF 1.1, supports RDFS and OWL 2 QL ontologies, and works with R2RML and Ontop mappings. Its SPARQL support covers most of version 1.1, including aggregation and GeoSPARQL functions. Documented database integrations range from PostgreSQL, MySQL, and Oracle to Snowflake, BigQuery, Redshift, and DuckDB; it also supports federators such as Trino, Denodo, and Apache Spark. Users can run a SPARQL endpoint through the CLI or Docker, create virtual views called lenses, or materialize graphs as RDF files. The CLI also handles metadata extraction, querying, validation, and mapping tasks. Ontop is free under Apache 2.0 and offers a Protégé plugin for editing and testing mappings, though that plugin does not support lenses. Database users must supply the appropriate JDBC driver.
Who it suits
Ontop suits teams that want to expose relational data through knowledge graphs and query it with SPARQL while keeping data in place. It fits users working with its documented databases, federators, and RDF or mapping formats.
Good to know, and what to watch
- Keeps graph data in its source databases
- Supports most SPARQL 1.1 features
- Connects to numerous databases and federators
- Offers CLI, Docker, and RDF materialization
- Free and licensed under Apache 2.0
- Requires users to obtain and place JDBC drivers
- Protégé plugin does not support lenses
- Generic JDBC may not handle every setup or query
The verdict
Ontop provides a broad route from relational databases to virtual knowledge graphs, with SPARQL querying and multiple deployment options. Check database-specific connector guidance and the Protégé plugin’s lens limitation before choosing it.
What the maker publishes
- CLI capabilities
- The CLI includes commands for bootstrapping, starting an endpoint, extracting database metadata, materializing RDF, querying, validating and manipulating mappings. source
- Database driver requirement
- Users must manually download the JDBC driver for their database system and place it in Ontop's jdbc directory. source
- Database integrations
- Documented database systems include PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, DB2, Snowflake, Databricks, Google BigQuery, AWS Redshift, DuckDB, AWS DynamoDB, and TDengine. source
- Data handling
- The graphs are virtual, so data remains in its source databases rather than being moved to another database. source
- Deployment
- Ontop can be deployed as a SPARQL endpoint using its command-line interface or Docker image. source
- Downloads
- The project says its distributions are available through GitHub, Docker Hub, SourceForge, and the Protégé plugin repository. source
- Federation integrations
- Ontop supports database federators including Denodo, Dremio, Teiid, Apache Spark, Trino, PrestoDB, and AWS Athena. source
- Generic JDBC caveat
- Ontop warns that generic JDBC support is not sufficient for any data source and is not guaranteed to handle every database setup and SPARQL query correctly. source
- Generic JDBC limitation
- The generic JDBC implementation is not recommended because it may not handle every database setup and SPARQL query correctly; dialect-specific connectors are available for listed systems. source
- Headquarters
- Bolzano, Italy source
- JDBC setup
- Users need to download the JDBC driver for their database system and place it in Ontop’s jdbc directory. source
- License
- Ontop is available under the Apache 2.0 license. source
- Mapping editor
- A plugin for the Protégé ontology editor lets users edit and test mappings, but it does not support lenses. source
- Materialization
- Ontop can materialize virtual graphs into RDF files. source
- Organizations
- The project says it is backed by the Free University of Bozen-Bolzano and Ontopic s.r.l., with regular contributions from Birkbeck, University of London, and Southeast University. source
- Other capabilities
- Ontop supports lenses as virtual views, can materialize virtual graphs into RDF files, and provides a Protégé plugin for editing and testing mappings. source
- Plugin limitation
- The Protégé plugin does not support lenses; the documentation recommends text editors or commercial offerings for advanced use. source
- Product
- Ontop is a Virtual Knowledge Graph system that exposes relational database content as knowledge graphs while leaving data in its source databases. source
- Project and license
- Ontop was initiated in 2009 by researchers at the Free University of Bozen-Bolzano and is available under the Apache 2.0 license. source
- Purpose
- Ontop exposes relational database contents as virtual knowledge graphs and translates SPARQL queries into SQL queries executed by the source databases. source
- Querying
- Ontop translates SPARQL queries over knowledge graphs into SQL queries executed by relational data sources. source
- SPARQL support
- It supports the majority of SPARQL 1.1 features, including main aggregation functions and GeoSPARQL functions. source
- Standards
- It uses RDF 1.1, supports RDFS and OWL 2 QL ontologies, and supports R2RML and Ontop mappings. source
- Support and commercial offerings
- The documentation says Ontopic provides a suite of solutions for leveraging Ontop and Virtual Knowledge Graphs; it does not state a support price or service level on that page. source
Checked against the maker's pages on 8 Oct 2026.