23 plugins in category «Database»

AndroidLibraryManager

The plugin is used to manage your library.

Berkeley DB Java Edition

By jeje
Berkeley DB Java Edition browser

Database Navigator

Database development, scripting and navigation tool
This product adds extensive database development and maintenance capabilities to the IntelliJ IDEA development environment and related products. Along with a qualified and IDE-compliant SQL and PL/SQL editor, it provides advanced database connection management, script execution support, database objects browsing, data and code editor, support for database compiler operations, method execution and debugging, database objects factory, as well as various navigation capabilities between all its components.
See features overview on the support page.

Supported Databases:
  • Oracle
  • MySQL
  • SQLite
  • PostgreSQL



This tool is free for personal and commercial usage.
Donations are very welcome though.

DB Visual Architect 1.0 for IntelliJ IDEA

DB Visual Architect for 1.0 for IntelliJ IDEA (DBVA-IJ) is a full featured Object Relational Mapping (ORM) plugin for IntelliJ IDEA that provides the industry's best round-trip code engineering support with Java. The tool act as a bridge between object model, data model and relational model by automating the mapping between relational rows in a database and object models which can be manipulated by a Java program, and helps realizing UML design to database implementation. Features of DBVA-IJ:
  • Database generation. You can design your application with Class Diagram and ERD within the industry's best visual modeling environment, and generate database table from the resulting diagrams.
  • Reverse Engineering database. Reverse engineer legacy database system (MySQL, Oracle, DB2, HypersonicSQL, MS SQL, Pointbase, Sybase, jTDS ...) to Class Diagram and ERD.
  • Java source code generation. Generate the persistent Java source code you need to access database(s). A Class will map to a database table. You can insert, update or delete database records with those generated Classes.
  • Multiple database support. Allows you to access various DBMS (MYSQL, Oracle, HSQLDB, MS SQL, Sybase ...) with the same set of persistent source code.
  • Reverse Engineer for Legacy System. Reverse XML, database tables through JDBC, Hibernate format, XML schema, .NET dll or exe files, Java source/class/jar files, C++ source files, CORBA IDL source files, Ada9x into Class models instantly.
  • Support of EJB Development. Design EJBs in Class Diagram, and perform bi-directional code generation between UML models and EJBs.
  • Diagram layout facility. Tidy up messy diagrams with the sophisticated layout facility. Various layout styles are available and each can be fine-tuned with a set of configurable parameters.
  • Ad-hoc documentation generation. Customize report in an intuitive report builder and update the report with the latest design from time to time. Report can be exported as OpenOffice format or Microsoft word format.
  • Teamwork Server. Share your design with your team members through your organization network or the Internet.
  • Modeling with Visio Stencil. You can model domain-specific system by using Visio stencil, beyond the standard UML notations.
  • Mouse gesture support. Execute commands in UML diagrams by holding down a mouse button and moves the mouse in a certain ways to from a gesture.
  • Object Relational Mapping (ORM) support. Generating the persistent Java source code you need to access database(s).
  • ER Diagram (ERD) support
  • Round-trip engineering between model and source code
  • Project exporting and merging
  • HTML and PDF report generation
  • Ability to export UML Diagram as images (JPEG, SVG, PNG)
  • Support of Rose model import
  • Support of XMI import
  • Template and Plugin Architecture
and much more...
Free evaluation is available from http://www.visual-paradigm.com/dbva.php

DB Visual ARCHITECT for IntelliJ IDEA

DB Visual ARCHITECT for IntelliJ IDEA (DBVA-IJ) is a single, easy-to-use object-relational mapping (ORM) environment which acts as a bridge between object model, data model and relational model. Here are the main features:
  • Enhanced Smart Resources
  • EJB Diagram Support
  • EJB Code Generation and Deployment
  • Enhanced Reverse Engineering a Database
  • Customizable SQL
  • Mapping One Class to Multiple Tables
For more infomration, please visit: http://www.visual-paradigm.com/product/dbva/ij/

db4o plugin

db4o integration - https://github.com/vltRz00r/db4o-plugin

DBHelper

A productivity tool to help you work with databases inside IDEA. This tool is targeted on the Java developers, who are also stored procedure developers. Key features include: 1) Adding two new file types IDEA can recognize: a. SQL – The SQL script file b. DIA – The database schema diagram file 2) Basic syntax highlighting – Supporting keywords, single line comments, /** **/ style multi-line comments, strings and number. The keyword is updated dynamically based on the database you are working with. 3) Code completion: a. Supporting basic completion: Hit Ctrl + Space lists all the objects in the current database and narrows down as the user typing b. Correlation name completion: When the user hits ‘.’, it will resolve the correlation name and pops up the suggestions, such as catalogs, schemas, table columns and stored procedures. It can also resolve SQL correlation name, temp tables, declared variables and parameters (works for SQL iAnywhere or ASE T-SQL format) 4) Run SQL script inside IDEA editor – At any time, the user can highlight a block SQL script or run the whole SQL script in IDEA editor and the result will show in the DBHelper output panel. 5) View Database schema as diagram – At any time, the user can select multiple tables or a type of tables and view the schema in a graphical diagram. The diagram can be saved as DIA format or copied as image. 6) Update table data – The user can view the data of any table and insert/delete/update the table data. 7) Support multiple databases via standard JDBC interface, tested databases are: a. Sybase SQL Anywhere (tested on version 9.x) b. Sybase ASE (tested on version 12.x) c. MySQL (tested on version 5.x) d. SQL Server (tested on version 2000) e. Oracle (tested on 9i) Extra database meta data can be supported by adding plugin jars to DBHelper (Implementing IMetaProvider interface, see ASA user meta extension sample) 8) It is designed to be extended using Velocity templates. (Velocity is an open source apache project for generating text content based on a simple template). Uses can add templates to generate customized content based on the database meta data, such as generating XML data based on resultset, or JDBC call to retrieve the resultset from the database. There are some templates come with this release as examples. 9) SQLConsole is newly added to support users that primarily don’t write lots of stored procedures and only want to run some simple queries inside IDEA. Users can open SQLConsole in DBOutput tool window and run any SQL queries. Of course syntax highlighting and SQL code completion are also available in the SQLConsole. 10) Query Manager: Users can create new or update queries in DBOutput tool window Saved Queries tab.

DbUnit Extractor

DbUnit Extractor - copy selected rows from SQL Console as DbUnit XML.

Authors
  • Pawel Salata
  • Robert Kapala
Source code and documentation Screen cast

Ebean 4.x Enhancement

Ebean enhancement for versions 4.x to 7.x

Ebean 8.x Enhancement

Ebean enhancement for 8.x

Ebean enhancer

Post-compile Ebean enhancement

Graph Database support

Integration with Graph Databases.

Features:

  • Manage data sources.
  • Write and execute queries.
  • Explore query results in graph or table view.

Supported databases:

  • Neo4j 3.0+ (Bolt)

Supported query languages:

  • Cypher
    • Understands queries in `.cyp`, `.cypher` or `.cql` files.
    • Syntax highlight and error reporting.
    • Refactoring support for identifiers, labels, relationship types and properties.
    • Autocompletion support for identifiers, labels, relationship types, properties and stored procedures. Information gathered from existing queries and configured data sources.
    • Auto-inject Cypher language for: neo4j, neo4j-ogm, spring-data-neo4j, neo4j-harness, py2neo.

Iedis

Plugin for Redis
Feel free to feedback

JalapenoDev

Jalapeño Development Environment

InterSystems Jalapeño (JAva LAnguage PErsistence with NO mapping) technology provides a new way for Java developers to rapidly build database applications.

Jalapeño lets Java programmers define data classes and build applications within their favourite Java development environments using object oriented techniques, and, because their data is persisted in Caché, still query it using SQL via JDBC, ODBC, Web Services or JPA Entity Manager. Jalapeño supports data-aware refactoring of object model, automatic test data population and creation of ANT scripts for common build and testing operations. Jalapeño is fully compatible with JPA and implements much of JPA functionality.

Jalapeño supports database independence by providing an export utility that will convert the Caché class schema (originally derived from pure Java class definitions) to a DDL file that can be imported into a relational database. The Object Manager automatically uses object persistence methods (Open, Save, New, Delete) when accessing Caché, and relational persistence methods (Select, Update, Insert, Delete) when it is configured to connect to a relational database.

Plugin Features:

  • Automatic database schema creation
  • Error reporting
  • Data-aware refactoring
  • Auto-completion of property names
  • Automatic test data population
  • Indices and constraints specification
  • Ant Script Support

Plugin does not include support for JavaEE Integration so it can run inside Community Edition of thr IDE. If you use Ultimate Edition Please install "Jalapeno Support for JavaEE" to enable JavaEE integration.

k-infinity

Support for k-infinity by Intelligent Views

k-infinity is a powerful semantic graph database.
More information about it is available at i-views.com.

This plugin integrates k-infinity into the JetBrains plattform products. It helps developers to work with the k-infinity database. Its features include support for k-infinity JavaScript, two-way script synchronization, inspections, intentions and quickfixes.


URLs:

LiquiBase EJB Integration

LiquiBase EJB Integration Plug-in for IntelliJ IDEA. Compares LiquiBase Database ChangeLog with EJB entity model providing inspections and intentions adding to ChangeLog.

Source available at https://github.com/marcusn/LiquibaseEjb

Examples include:
* Add a new entity -> inspection to add liquibase addTable
* Add a new entity field -> inspection to add liquibase addColumn
* Change type of field -> inspection to add liquibase modifyColumn
* Rename field -> dialog to add liquibase renameColumn.

Other features:
* Liquibase EJB facet to configure and create changelog file.
* Context sensentive completion of table and column names within a changelog file.
* Tool window with schema as would be created by liquibase changelog as well as EJB model.

Restore Sql for iBatis/MyBatis

Restore the ibatis/mybatis generate sql to original whole sql.
It will generate sql statements with replace ? to the really param value.
Through the "Tools -> Tail restore sql in Console" menu you can tail the sql log.
You can selected the "Format Sql" button on the left to format the generate sql statements.

SQL Code Assistant

SQL Code Assistant provides extended editing capability for SQL and PL/SQL code of the Oracle database.
With the SQL Code Assistant you are able to browse the objects, edit and execute SQL statements, navigate over the code, search for usages in the database schema or scripts on the File System.

The plugin uses lexer and parser generated by ANTLR tool, thanks to Terence Parr (parrt@cs.usfca.edu, parrt@antlr.org).

Feature list:
  • Configurable syntax and error highlighting
  • Static code analysis
  • Context aware code completion
  • Viewing the structure of SQL and PL/SQL code
  • SQL and PL/SQL code formatting (experimental) (Ctrl-Alt-L)
  • Code Navigation
  • Quick object lookup (Ctrl-Shift-O)
  • Explain Plan (Ctrl-Shift-P)
  • Find Usages tables, views, columns, function, procedures, etc
  • Run SQL statement or PL/SQL block against active connection (Ctrl-Shift-M)
  • Database Schema Browsing
  • Set up database connection with plain JDBC URL or TNS Names, also SSH tunnel supported
  • Code Folding and bracket matching support
  • Code commenting

NOTE: Put SQL and PL/SQL files under some of source roots to have them indexed by the plugin.
Latest changes:
  • Completion wizards for TABLE/PROCEDURE/FUNCTION/PACKAGE
  • [KNOWN ISSUE] Case-sensitive table names, column names, etc are not supported for now
  • [KNOWN ISSUE] Initial indexing of numerous SQL files (1k and more) may take time

I appreciate comments, suggestions or bug reports, thanks in advance.
Version 1.6.1.133

SQL DAL Maker

By ss-20
SQL DAL Maker is a generator of DTO and DAO classes. Target programming languages: PHP, Java, C++, Python, Ruby.

To generate the class, you declare it in XML meta-program. Example:

<dto-class name="Order" ref="getOrders.sql" />

<dao-class>
  <crud-auto dto="Order" table="orders" />
  <query-dto-list method="getOrders(d1, d2)" ref="getOrders.sql" dto="Order" />
</dao-class>

Sql Generator

idea Sql Generator plugin

SQL Query Plugin

A tool for executing SQL statements through a JDBC connection.

Features:

  • Syntax highlighting
  • Executing multiple statements at once
  • Highlighting of primary and foreign keys
  • Editing of results
  • Support for easier configuration of common JDBC driver
  • Support of different column formats (including custom formats)
  • Browser for database structure
  • Statement templates for often used statements
  • Support for Java BLOB's
  • Export into XML, HTML, CSV and Excel
  • Data Load

SQLHelper

SQLHelper is a simple tool for generation Java code to work with SQLite database. The following features are available:
  • Generation of Java code that implements the basic functions to work with databases : update, delete, insert and select
  • Generation of Java code that uses sqlite-jdbc 3.7.2
  • Generation of Java code that uses Android SDK
  • Editing database on the device or on your computer
  • Push or Pull database file using Android Debug Bridge
  • Creating SQL queries
  • Device monitor, which will help you navigate the connected device or emulator
Requirements
  • Android Debug Bridge 1.0.32
  • Root access on device
  • sqlite3 on device

SQLScout (SQLite Support)

First-class SQLite support for Android Studio and IntelliJ IDEA.

View, manage and update SQLite databases in your Android device ( in real time) and file system, from Android Studio and IntelliJ IDEA.