Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
With Aqua Data Studio's support for MongoDB, we're making it possible to execute SQL queries against one of the most widely adopted NoSQL database management systems. This means that you don't have to be a JSON expert to retrieve and examine data from a MongoDB deployment. Want to create a Collection without typing a line of code? No problem, because our Visual Editor allows you to create collections and even specify collection attributes such as Capped and Storage Size. You can execute queries using our SQL-92 based MongoSQL syntax and with a single click export the data into Excel. We've brought all of our easy-to-use and feature rich database functionality to MongoDB; so if you know SQL, you'll feel right at home. In addition, if you're looking for a javascript interactive mongo shell, we've got you covered with MongoShell.
Supports MongoDB 2.2 or higher
Execute SELECTs, INSERTs, DELETEs, complex WHERE clauses, GROUP BYs, ORDER BYs, CREATE and DELETE collections and much more using our SQL-92 like SQL Syntax for MongoDB. By using standard SQL, you don't have to learn the mongo shell syntax or become a JSON expert and can leverage Aqua Data Studio's powerful charting and data analysis capabilities. <link>MongoDB SQL Query Reference</link>
Explore your MongoDB server's contents by using the Schema Browser: a visual tree that shows the contents of all of your Schema Objects. Right click on an object to view its properties, create new objects, or alter existing ones.
Add MongoDB collections and columns, modify collections and even edit the data within a collection using an excel-like grid via Aqua Data Studio's Table Data Editor. Using Query Builder, you can even create complex join statements without ever typing a line of SQL code, but still see the SQL it's writing for you.
Configuring permissions in your MongoDB database is simplified through the Security component of the Schema Browser. Efficiently create and edit Users with our Visual Editing UI, giving only the database object and schema permissions users need.
Right click on a MongoDB object in the Schema Browser and you can script it as CREATE, ALTER, DROP to have Aqua Data Studio generate DDL for you. With the Schema Script Generator you can pick and choose which objects to script, or script the entire contents of a server.
Connect to MongoDB and execute SQL queries effortlessly by using intelligent Autocomplete, SQL Abbreviations and SQL Automation. Perform advanced analysis by using the built-in Pivot Grid and Charts, or one-click export to Excel.
Learn more
Rapidly create MongoDB Databases, Collections, Indexes and much more through Aqua Data Studio's highly streamlined Visual Editing UI. Drop objects just as easily.
Learn more
Use powerful, Excel-like grid editing of your MongoDB collection data. Edit any resultset and access features such as find/replace, copy, paste, delete, insert, alter, and copy rows with a single click. Preview the resulting SQL statements prior to executing them.
Learn more
Use our UI's built-in ETL functionality to import data, massage it to suit your needs and even export it in a different format. Use Aqua Data Studio's wizards to walk you through, step by step, importing data into existing MongoDB collections and exporting MongoDB data based on your desired format.
Learn more
Script a complete MongoDB database to file, including CREATE, DROP DDL and INSERT DML without ever typing an SQL command. Save the generated scripts for later or share them with coworkers.
Learn more
Rapidly generate SQL scripts for MongoDB server objects such as Groups and Users. Script as a single file, or create an individual file per object into a folder.
Learn more
Create and manage MongoDB ER diagrams. From a simple reverse engineering of your existing database to designing a highly complex diagram involving thousands of entities, you can annotate, forward engineer, perform diffs, generate HTML reports and much more.
Learn more
Use Open APIs to create fully automated end-to-end solutions for your MongoDB databases using JavaScript. Aqua Data Studio provides a full-fledged IDE with APIs to MongoDB database access, schema DDL generation, Grid and Pivot Grid charts, version control and much more.
Learn more
Generate great looking charts and graphs from your MongoDB database content. Choose from a variety of chart types and customize until you've designed exactly what you need to visualize your data. All charts are updated in real time based on your query results. You can even pivot your data and create charts based off of your pivoted data.
Learn more
Automate your database ETL tasks using FluidShell, an interactive shell which combines the power of an SQL command line with the versatility of a Unix shell.
Learn more
MongoShell provides an interactive JavaScript shell with nearly identical syntax and functionality to the native mongo shell.
Learn more
Quickly determine the differences between MongoDB Schema Objects, Databases, Indexes and more by using the Schema Compare tool. Generate HTML reports of the results once your comparisons are done.
Learn more
After you've generated results from a query, use the Results Compare Tool to search, filter and sort differences. Generate HTML reports of the comparison to share with others.
Learn more
Find the Database Objects you are looking for quickly and easily within your MongoDB database server. Narrow your search by Schema and Object Type and enter the text to find.
Learn more
Construct sophisticated database queries without ever writing a line of SQL. Use our UI to select tables and columns and leverage our rich set of visual options including GROUP BYs, SORT ORDER, equality comparisons and more.
Learn more
Automatically record and archive all of the queries you run on MongoDB servers and store them in a centralized location for auditing purposes. View a history of all the SQL statements and scripts that have been executed within the Query Analyzer, Query Builder and Table Data Editor. Execute a query from months or even years ago.
Learn more