Reveal Pro: SQL DB explorer
SQL DB explorer
You can get a better view of SQL database you use in your project using
db:explore action on your JDBC connection source description (e.g. DataSource instance, JDBC URL or, if you use next.jdbc or clojure.java.jdbc, a db spec map).
Here is what you can do with DB explorer:
Visualize database schema.
You can view your database in the same way you think about it — as a graph with relations.
Explore relational data across multiple tables without writing joins.
You can load data from multiple tables using schema-aware relation and column picker. In the same picker interface, you can apply free-form filters to columns, quickly getting the data you need.
Work with query results in the REPL.
Working with data loaded from the database usually requires post-processing. With this explorer, you don’t need to perform an export/import step that is necessary with external SQL clients — query results are available in the REPL as simple data structures.