![]() Graphic query editor with different join types, filters and group by. Moving the mouse over columns and tables in the web browser may read the schema comments. Graphical explain query execution plan included.Įxport the diagram as interactive HTML5 vector image. SQL editor with syntax highlighting and code completion can execute queries, SQL or groovy scripts. If your schema misses foreign keys, create virtual foreign keys: they will be saved to DbSchema project file and can be used in Relational Data Browse, Query Builder or for documentation purposes. The project design file is in XML format and can be stored in GIT or SVN. You may work on a development schema and later deploy it on the production databases. Schema will be saved together with the diagrams to project file.ĭbSchema holds its own image of the schema which can be compared and synchronized against any database. Data can be edited directly here, filters and sorting can be applied.Ĭonnect to any relational database or one of the supported noSql databases, reverse engineer the schema and view it as ER diagrams. The editor is persisted and will be reopen next time when you start the application. Start exploring data from one table and cascade into further tables based on foreign keys. Visual alternative to SQL language, the editor offers simultaneous views of the data from multiple tables. For a better understanding of the schema create multiple layouts (diagrams), one for each module of the schema, with the same or different tables. NoSQL: MongoDB, Cassandra, HBase, Hive.Įdit tables and columns directly in the diagram.For ALL SQL databases: SqlServer, Postgresql, MySql, MariaDb, Oracle, Db2, Sybase, Sqlite, and more plus.No database experience required – the tool is visual. DbSchema performs well with large schemes and databases. ![]() The project file is in XML format and can be shared in a team using GIT. DbSchema uses its own project with schema structure and diagrams – this makes possible to deploy schema on multiple databases. ![]() ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |