Page History
Aqua Data Studio
...
Contents
- Schema Browsing
- Visual Editing
- DDL Scripting
- Management
- Security
- Features Supported in SingleStore (MemSQL)
Schema Browsing
Explore your SingleStore (MemSQL) server's schema by using the Schema Browser. Schema Browser is 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.
Visual Editing
Add SingleStore (MemSQL) tables and columns, modify table constraints, and create new schemas. Edit your table data using an Excel-like grid via Aqua Data Studio's Table Data Editor. Use Query Builder to create complex join statements without ever typing a line of SQL code and see what the SQL Aqua Data Studio is generating for you.
DDL Scripting
Script a SingleStore (MemSQL) object as CREATE, ALTER or DROP for Aqua Data Studio to generate DDL. With the Schema Script Generator, you can either choose objects to script or script the complete content of a schema.
Features supported in SingleStore (MemSQL)
Management
View activity information about your SingleStore (MemSQL) deployment including the Process ID, User, Database, the status of Current Queries and more.
Security
Maintain Security for your SingleStore (MemSQL) database through the Security component of the Schema Browser. Create, Alter, and Drop Users and Groups, by assigning and altering permissions.
v23.2 is now using Idera's documentation wiki, in an effort to better support and maintain the latest Aqua Data Studio documentation updates and refreshes.
Documentation can now be downloaded in CHM, DOCX, and PDF formats.
Query Analyzer
Connect to SingleStore (MemSQL) 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 feature.
Learn more
Table Data Editor
Use powerful, Excel-like grid editing of your SingleStore (MemSQL) table data. Edit any result set 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
Import/Export Tool
Use our UI's built-in ETL functionality to import data, configure it to suit your needs, and export it in a different format. Use Aqua Data Studio's wizards to step by step import data into existing SingleStore (MemSQL) tables and exporting SingleStore (MemSQL) data based on your desired format.
Learn more
ER Modeler
Create and manage SingleStore (MemSQL) 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, performs diffs, generate HTML reports and much more.
Learn more
Visual Analytics
Generate beautiful charts and graphs from your SingleStore (MemSQL) database content. Choose from a variety of chart types and customize the way you want to visualize your data. Visual Analytics gives you a clear picture of what your data means.
Learn more
Charts
Generate beautiful charts and graphs from your SingleStore (MemSQL) database content. Choose from a variety of chart types and customize the way you want to visualize your data. Visual Analytics gives you a clear picture of what your data mean as it updates your charts in real time based on your query results. You can even pivot your data and create charts based on your pivoted data.
Learn more
Schema Compare Tool
Use the Schema Compare tool to determine the differences between SingleStore (MemSQL) Schema Objects, Databases, Functions, Packages, and more quickly. Generate HTML reports of the comparison results.
Learn more
Results Compare Tool
After generating results from a query, use the Results Compare Tool to search, filter and sort differences. Generate and share HTML reports of the comparison results.
Learn more
Visual Query Builder
...