8 plugins in category «Database»

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.

DbUnit Extractor

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

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

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

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:

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 Generator

Data Source extension plugin. generate the following SQL statement.
  • SELECT(condition by primary key)
  • INSERT
  • UPDATE(condition by primary key)
  • DELETE(condition by primary key)

Sql Generator

idea Sql Generator plugin