Alternatives to Advanced Query Tool (AQT)
Compare Advanced Query Tool (AQT) alternatives for your business or organization using the curated list below. SourceForge ranks the best alternatives to Advanced Query Tool (AQT) in 2024. Compare features, ratings, user reviews, pricing, and more from Advanced Query Tool (AQT) competitors and alternatives in order to make an informed decision for your business.
-
1
DbVisualizer
DbVisualizer
DbVisualizer is one of the world’s most popular database editors. Developers, analysts, and DBAs use it to elevate their SQL experience with modern tools to visualize and manage their databases, schemas, objects, and table data, and to auto-generate, write and optimize queries. And so much more. It connects to all popular databases (e.g. MySQL, PostgreSQL, SQL Server, Oracle, Cassandra, Snowflake, SQLite, BigQuery, and 20+ more) and runs on all popular OSes (Windows, macOS, and Linux). With almost 6 million downloads and Pro-users in 145 countries around the world, it won’t let you down. Free and Pro versions are available. -
2
PopSQL
PopSQL
PopSQL is a collaborative SQL editor and workspace that connects everyone in the data analysis process so that teams can obtain better data insights and visualizations by asking the right questions, together. * Get answers faster with real-time collaboration, version history, searchable shared queries and folders. We make it easy for your power SQL users and data analysts to work with business stakeholders * Built-in data visualization & sharing lets you go from query to chart to Slack in seconds. Build, schedule and push real-time insights and dashboards, in just a few clicks. * Our modern and elegant cloud-based workspace offers a rich SQL editing experience. Dive right in, connect to your databases and iterate on analyses from anywhere. We offer native macOS, Windows, and Linux clients. * One workspace to get it done: PopSQL puts your database connections, shared credentials and an intuitive data catalog at your fingertips so you can access & mine your data, safely, securelyStarting Price: $199 per month -
3
dbForge Studio for PostgreSQL is a GUI tool for database development and management. The IDE for PostgreSQL allows users to create, develop, and execute queries, edit and adjust the code to your requirements in a convenient and user-friendly interface. The tool provides a data editing tool to customize your queries and property window so that users can view all the required information of PostgreSQL database objects they are interested in. Key features: *SQL Development. Save your time and improve code quality when creating and editing queries. *Explorer. Navigate through the object tree and find any PostgreSQL object you want. *Data Editor. Users can manage the settings of tables. *Data Export and Data Import. Supports 10+ widely used data formats, a number of advanced options, and templates for recurring scenarios. *Query Profiler. *Data and Schema Compare. *Data Generator. *Pivot Table.Starting Price: $89.95
-
4
AnySQL Maestro
SQL Maestro Group
AnySQL Maestro is the premier multi-purpose admin tool for database management, control and development. SQL Maestro Group offers complete database management and web development solutions for all the most popular database servers providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Support of any database engine (SQL Server, MySQL, Access, etc.) Database designer, data management, editing, grouping, sorting and filtering abilities. Handy SQL Editor with code folding and multi-threading. Visual query builder, data export/import to/from the most popular formats. Powerful BLOB viewer/editor. The application also provides you with a powerful set of tools to edit and execute SQL scripts, build visual diagrams for numeric data, compose OLAP cubes, and much more. High-quality DB2 tools which are as easy in use as Windows explorer.Starting Price: $79 one-time payment -
5
Database Tour Pro
Vitaliy Levchenko Software
Here are some areas where Database Tour has competitive advantages among database tools in the marketplace. Preparing database queries in SQL editors with syntax highlighting, code completion, and Ctrl+clickable objects. Multiple windows with separate transactions. There is a possibility to execute multi-statement SQL scripts. Collecting SQL execution statistics for each query window. Performing useful operations with databases, such as searching and replacing text, batch data processing etc. Database Tour data grids give you the ability to view CLOB/MEMO (large text) and graphic data, expand rows, use autoscrolling, sorting, selecting group of records, copying data etc. Data in tables can be highlighted depending on its content (so called conditional formatting). There is a tool for working with BLOB fields, such as large text and graphics. -
6
SQL Workbench
SQL Workbench
SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. It is written in Java and should run on any operating system that provides a Java Runtime Environment. Its main focus is on running SQL scripts (either interactively or as a batch) and export/import features. Graphical query building or more advanced DBA tasks are not the focus and are not planned. Powerful export command to write text files (aka "CSV"), XML, HTML or SQL (including BLOB data). All user tables can be exported into a directory with a single command. Export files can be compressed "on-the-fly". Powerful text, XML and spreadsheet import. A set of files (including compressed files) can be imported from a directory with a single command. Foreign key constraints are detected to insert the data in the correct order. Compare two database schemas for differences. The XML output can be transformed into the approriate SQL ALTER statements using XSLT. -
7
RazorSQL
RazorSQL
RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, macOS, Mac OS X, Linux, and Solaris. RazorSQL has been tested on over 40 databases, can connect to databases via either JDBC or ODBC. Browse database objects such as schemas, tables, columns, primary and foreign keys, views, indexes, procedures, functions, and more. Visual tools to create, alter, describe, execute, and drop database objects such as tables, views, indexes, stored procedures, functions, triggers, and more. Includes multi-tabular display of queries with options for filtering, sorting, searching, and much more. Import data from various formats such as delimited files, Excel spreadsheets, and fixed-width files. Includes a robust relational database (HSQLDB) that is up and running with no manual configuration out of the box.Starting Price: $99.95 one-time payment -
8
EMS SQL Management Studio
EMS Software
EMS SQL Management Studio for PostgreSQL is a complete solution for PostgreSQL database administration and development. The single workbench provides you with must-have tools for managing PostgreSQL databases and objects, as well as for database design, migration, extraction, query building, data import and export, database comparison, and running service tasks. Get access to all databases and their objects from a single console and manage them with a user-friendly interface. You can create and modify all server and database objects, set necessary properties, and view detailed info in advanced visual editors. Transfer structure changes from development to production database automatically with Compare databases tool. Create ER diagrams for newly developed databases to quickly deploy them. Create database maintenance tasks with advanced options and let SQL Studio run them on a regular basis.Starting Price: $260 one-time payment -
9
dbForge Studio for SQL Server is a comprehensive platform with an intuitive graphical user interface and robust functionality that enables users to handle a variety of database-related tasks both on-premises and in the cloud. Key Features: T-SQL editor with intelligent code completion, debugging, formatting, and more Database schema and data comparison and synchronization Source Control with support for all popular version control systems Visual database designer with ER diagrams. Visual Query Builder for constructing complex T-SQL queries Data import and export Data generator of high-quality test data Real-time database monitoring Query Profiler with analysis and optimization Data analysis, visualization, and reporting Automatic database documenting Task automation via the Command line dbForge Studio for SQL Server is a powerful alternative to SSMS. It offers the features of the default SQL Server IDE along with many additional tools and options.Starting Price: $229.95
-
10
dbForge SQL Complete
Devart
dbForge SQL Complete is a powerful coding assistance tool available as an add-in for SQL Server Management Studio (SSMS) and Visual Studio (VS). It offers numerous features to enhance code quality and accelerate code creation within the standard interface. Key Features: - Context-aware suggestions for keywords and objects - T-SQL debugger - Flexible SQL formatting - Safe and fast code refactoring in large databases - Customizable code snippets with the ability to create user-defined snippets - Execute statements against the target database directly from the SQL Complete window - Various data visualization options - Customizable execution warnings and notifications - Quick access to database object descriptions - Query history with the ability to restore lost or closed documents or tabs dbForge SQL Complete greatly reduces human typing errors. Its integration with SSMS enhances coding capabilities, providing users with a robust toolset.Starting Price: $129.95 -
11
SQL Manager
EMS Software
SQL Manager for PostgreSQL provides a set of easy-to-use visual editors for any database or server objects. You can create complex queries visually or use editor tool with code completion, code folding, formatting and many other useful features. You can adjust editor view to meet your requirements. Query results can be easily exported to any format. Manipulate data with filters, grouping, sorting and sub-levels, view it as JSON, Image or XML and export it into any of popular formats, including XLSX, CSV, TXT, XML, SQL and more. Advanced import from MS Excel, MS Access, DBF, XML, ODF, TXT, CSV, etc. with selecting the method of adding data to the already existing tables, as well as processing or replacing of inserted data. Data export into a variety of popular formats: MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF and more with flexible setting for the result data view. -
12
dbForge Schema Compare for MySQL is a fast, easy-to-use tool to compare and synchronize structures of MySQL, MariaDB and Percona databases. The tool provides a comprehensive view of all differences between MySQL, MariaDB and Percona database schemas, generates clear and accurate SQL synchronization script that can be used to update database schema. Key features: * Fast comparison of any databases, including extra-large ones * Clear display of comparison results * Capability to save and load comparison settings * Filtering, sorting, grouping for efficient management of compared objects * Text comparison feature shows DDL differences of compared objects * Synchronization script preview for any compared object * Schema synchronization wizard allows you to generate a standard-driven synchronization script with additional options * Integrated SQL editor for advanced work with SQL scripts and query files * Well-tested functionality, reliable and safe for your databaseStarting Price: $89.95
-
13
dbForge Query Builder for MySQL is a visual tool that allows creating any sort of MySQL queries, from simple lookups to complex JOINs. The tool provides broad compatibility options and helps constructing and editing complex MySQL queries in a few clicks. You don't need to sweat building complex code - just "draw" your query on a diagram. Key Features: * Powerful visual MySQL query builder functionality * MySQL statement generator executes created queries and edits tables data * Combine a few queries to a sub-query via visual MySQL query editor * Manage databases proactively * Easily make JOINs between tables * Discover trends from mountains of data * Cut the time you spend on writing complex queries You can always find the latest version of the product on the official Devart website.Starting Price: $79.95
-
14
DbSchema
Wise Coders Solutions
DbSchema is for visual designing the schema in a team, deploy and document the schema. Other integrated features like data explorer, visual query editor, data generator, etc., makes DbSchema an every-day tool for everybody who interacts with databases. DbSchema supports all relational and No-SQL databases, including MySQL, PostgreSQL, SQLite, Microsoft SQL Server, MongoDB, MariaDB, Redshift, Snowflake, Google and more. DbSchema is reverse-engineering the database schema from the database and visualize it as diagrams. You will interact with the database using diagrams and visual tools. DbSchema model is using its copy of schema structure, independent from the database. This allows the schema deployment on multiple databases, save the design model to file, store it in GIT and design the schema in a team, design the schema without database connectivity, compare different versions of the schema and generate SQL migration scripts.Starting Price: $63 one time payment -
15
dbForge Studio for Oracle
Devart
dbForge Studio for Oracle is a powerful integrated development environment (IDE) which helps Oracle SQL developers to increase PL/SQL coding speed, provides versatile data editing tools for managing in-database and external data. This Oracle IDE allows synchronizing data between different Oracle servers and automating schema change management process during development. dbForge Oracle GUI features powerful functionality wrapped into a smooth management Oracle GUI consistent with Microsoft Visual Studio. Key features: * PL/SQL coding assistant * Database Project * Oracle Database Management * Data Generator * Documenter * Object Manager * Oracle PL/SQL Debugger * Query Builder * Query Profiler * Schema Import/Export * Database Administration * Database Designer * Import/Export Data * Report and Analysis * Find Object You can always find the latest version of the product on the official Devart website.Starting Price: $149.95 -
16
SSuite MonoBase Database
SSuite Office Software
Create relational or flat file databases with unlimited tables, fields, and rows. Includes a custom report builder. Interface with ODBC compatible databases and create custom reports for them. Create your own personal and custom databases. Some Highlights: - Filter tables instantly - Ultra simple graphical-user-interface - One click table and data form creation - Open up to 5 databases simultaneously - Export your data to comma separated files - Create custom reports for all your databases - Full helpfile to assist in creating database reports - Print tables and queries directly from the data grid - Supports any SQL standard that your ODBC compatible database requires Please install and run this database application with full administrator rights for best performance and user experience. Requires: . 1024x768 Display Size . Windows 98 / XP / 7 / 8 / 10 - 32bit and 64bit No Java or DotNet required. Green Energy Software. Saving the planet one bit at a time...Starting Price: Free -
17
dbForge Data Compare for Oracle is a powerful, fast and easy tool for comparing and synchronizing Oracle databases. It helps you quickly compare data in tables, view the differences at a glance and execute an automatically generated script to eliminate these differences. dbForge Data Compare for Oracle has a graphical wizard that will guide you through the Oracle data comparison and synchronization process step by step. Key Features: * Wide support for Oracle server versions and objects to be compared * Comparison and synchronization options * Data comparison and analysis * Automate routine tasks * Sync data You can always find the latest version of the product on the official Devart website.Starting Price: $119.95
-
18
DBHawk
Datasparc
Using DBHawk, our customers were able to comply with GDPR, HIPAA, SOX, GLBA, and other regulations and were able to implement SOD. Self-Service BI & Ad-Hoc Reporting Tool with feature to define Data Access Policy, Connect to multiple Data sources, Build Powerful SQL Charts and data Dashboards. DBHawk SQL editor is an advanced editor that allows users to build, edit, and run database queries with a web-based interface. DBHawk Query Builder is supported with all major databases such as Oracle, Microsoft SQL Server, PostgreSQL, Greenplum, MySQL, DB2, Amazon Redshift, Hive, Amazon Athena. Database SQL tasks and batch job automation with a web-based centralized tool. Secure access to SQL, NoSQL and Cloud databases with our all-in-one data platform. Trusted by our customers to protect and access their data. Centralized Security, Auditing and insights about your user’s activities.Starting Price: $99.00/month/user -
19
dbForge Data Compare for MySQL is a fast, easy-to-use tool to compare and synchronize data of MySQL, MariaDB and Percona databases. The tool provides clear view of differences between data, allows analyzing them, generates synchronization script and applies changes at a glance. It also allows scheduling regular MySQL data comparisons using command line. Key Features: * Support of all MySQL versions * Support of MariaDB * Percona Support * Custom mapping of tables, columns, and views * Convenient comparison wizard * Full control of data synchronization * Integrated SQL editor * Code completion and SQL Code Formatter. These features offer the extended list of suggestions during the typing of SQL code and object information on different database objects. Profile formatting capabilities allow users to create new profiles and edit the existing ones easier than ever.Starting Price: $89.95
-
20
Hue
Hue
Hue brings the best querying experience with the most intelligent autocomplete and query editor components. The tables and storage browsers leverage your existing data catalog knowledge transparently. Help users find the correct data among thousands of databases and self-document it. Assist users with their SQL queries and leverage rich previews for links, sharing from the editor directly in Slack. Several apps, each one specialized in a certain type of querying are available. Data sources can be explored first via the browsers. The editor shines for SQL queries. It comes with an intelligent autocomplete, risk alerts, and self-service troubleshooting. Dashboards focus on visualizing indexed data but can also query SQL databases. You can now search for certain cell values in the table and the results are highlighted. To make your SQL editing experience, Hue comes with one of the best SQL autocomplete on the planet.Starting Price: Free -
21
Valentina Studio
Paradigma Software
Create, administer, query and explore Valentina DB, MySQL, MariaDB, PostgreSQL and SQLite databases for FREE. Design business reports running in Valentina Studio Pro, on Valentina Server or in an application with an Application Developer Kit. Backward Engineering in Standard with forwarding Engineering in Valentina Studio Pro. Reverse engineering and create diagrams for existing databases. Add new objects to diagrams. Write SQL queries with auto-completion, color syntax. Define, manage, save favorite queries; access recent queries. Function browser dictionary of each function. Consoles for errors, warnings, and performance. Search, Export result records into CSV, JSON, Excel. Edit properties of multiple objects at the same time. Drill down to tables and fields; incredible fast searching. Reverse engineering and create diagrams for existing databases. Add new objects to diagrams. Add/drop users, and groups, and manage privileges. -
22
Data Loader
Interface Computers
Data Loader is a simple, yet powerful tool capable of Synchronizing, exporting and importing data between many common database formats. If you wish to convert MS SQL Server, CSV or MS Access to MySQL, this is the best tool to satisfy your specific needs effectively. The latest Data Loader Version supports MySQL, Oracle, MS Access, Excel, FoxPro, DBF, MS SQL Server, CSV and Delimited or Flat Files. You can now easily convert Oracle to MySQL or MS SQL Server using this tool equipped with several unique and advanced features. For example, while transferring, you can filter columns and specify WHERE conditions. Similarly, Data Loader supports full mapping of source columns to target table columns. Other notable features include bulk inserts, built-in scheduler, UPSERT and INSERT, folder polling, command-line interface, etc.Starting Price: $99 one-time payment -
23
MongoLime
MongoLime
MongoLime allows you to easily manage and precisely control your MongoDB connections. Viewing and managing documents. Statistics, Indexes and other operations. Create and modify documents with a convenient MongoLime editor. Use raw JSON editor for complex documents. Search for documents using query builder. Save searches for a quick access. Export Databases and Collections in a JSON format as a ZIP archive. MongoLime is an application created to work with MongoDB databases on mobile devices and tablets running Android. The application’s interfaces are designed for easy data collection management. The application allows you to connect to MongoDB databases directly or in the Replica Set mode.Starting Price: $16 one-time payment -
24
JackDB
JackDB
Write and execute queries in a fully interactive SQL editor. JackDB has everything you'd want in a database client, including: syntax highlighting, code formatting, and intelligent autocompletion. Snippets allow your most useful SQL queries to be saved and shared. Simply write and save any query in JackDB, and share the snippet publicly with your team. Whenever anyone updates a snippet, everyone gets access to its latest version. Security is our highest priority at JackDB. Roles are a very convenient and secure way to restrict database access to authorized users and provision new users with access to data sources. Explore everything in your database, not just tables and views. View your indexes, schemas, and other important system details such as tablespaces and user sessions.Starting Price: $49 per user per month -
25
Azure Data Studio
Microsoft
Azure Data Studio is a cross-platform database tool for data professionals who use on-premises and cloud data platforms on Windows, macOS, and Linux. Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal. It's engineered with the data platform user in mind, with the built-in charting of query result sets and customizable dashboards. Use Azure Data Studio to query, design, and manage your databases and data warehouses wherever they are, on your local computer or in the cloud. We recommend the user installer, which simplifies installations and updates and doesn't require Administrator privileges. -
26
Raijin
RAIJINDB
In order to deal with sparse data, the Raijin Database uses a flat JSON representation for the data records. The Raijin Database supports SQL as its primary query language while lifting some of SQL's limitations. Data compression not only saves disk space but provides a performance boost with modern CPUs. Most NoSQL solutions are inefficient at or totally lack support for analytical queries. Raijin DB supports group by and aggregations using standard SQL syntax. Vectorized execution and cache-friendly algorithms allow large amounts of data to be operated on. Backed by optimized SIMD instructions (SSE2/AVX2) and a modern compressed hybrid columnar storage layer it ensures that your CPUs are not wasting cycles. This gives unparalleled data-crunching capabilities an order of magnitude faster compared to other solutions written in higher level or even interpreted languages which are inefficient at processing large amounts of data. -
27
MigrateEmails SQL Database Repair Tool
MigrateEmails
MigrateEmails SQL Database Repair Tool is a top-notch software to recover and restore damaged SQL database files. This tool is designed with multiple file recovery mods that enable users to easily fix severely corrupted MDF and NDF files. This advanced software can also restore database objects like Tables, rows, rules, functions, queries, indexes, etc. Using the SQL Database Recovery Tool, users can either save the recovered data to a Live Server or save it as a script. The demo version of this software can only preview the recovered SQL database files and not save them. Its interactive interface makes it easy to use by both technical and non-technical users. The SQL database repair tool runs smoothly on all Windows OS.Starting Price: $129 -
28
DataGrip
JetBrains
Meet DataGrip, our new database IDE that is tailored to suit the specific needs of professional SQL developers. Allows you to execute queries in different modes and provides a local history that keeps track of all your activity and protects you from losing your work. Lets you jump to any table, view, or procedure by its name via the corresponding action, or directly from its usages in the SQL code. Gives you an extended insight into how your queries work and into the database engine behavior, so you can make your queries more efficient. DataGrip provides context-sensitive code completion, helping you to write SQL code faster. Completion is aware of the tables structure, foreign keys, and even database objects created in code you're editing. DataGrip detects probable bugs in your code and suggests the best options to fix them on the fly. It will immediately let you know about unresolved objects, using keywords as identifiers and always offers a way to fix the problems.Starting Price: $199 per year -
29
WinSQL
Synametrics Technologies
WinSQL is a powerful universal database management tool that is used by 90 percent of Fortune 500 companies and more than a million programmers and DBAs around the globe. WinSQL is a generic querying tool that connects to any relational database (RDBMS) for which an Open Database Connectivity (ODBC) driver is available, virtually all RDBMS on the market today. Connect to a variety of databases, including: heavy duty vendors Oracle, MS SQL Server, DB2, Sybase, Informix to lightweight backends like MS Access, DBase, and Text File. Generate royalty-free executables that can be used by your business users to run queries. These can be either static or dynamic queries that pull fresh data from the back-end. Export or simply open any query results into MS Excel with just a click of your mouse. You can even import an existing Excel spreadsheet to a database table by simply dragging an *.XSL file in the catalog tree.Starting Price: $99.00/year/user -
30
Dolt
DoltHub
Version control features from Git on your SQL database tables. Commit, branch, merge, clone, pull, and push your data and schema. Use a familiar interface to query data and explore history as of time, commit, branch, or tag. Dolt solves this problem with a special type of replica you add to an existing MySQL deployment. No migration is required. You get an audit log of every cell, time travel, and branch for development on a replica.Starting Price: $50 per month -
31
MySQL Workbench
Oracle
MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X. MySQL Workbench enables a DBA, developer, or data architect to visually design, model, generate, and manage databases. It includes everything a data modeler needs for creating complex ER models, forward and reverse engineering, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort. MySQL Workbench delivers visual tools for creating, executing, and optimizing SQL queries. The SQL Editor provides color syntax highlighting, auto-complete, reuse of SQL snippets, and execution history of SQL. The Database Connections Panel enables developers to easily manage standard database connections. -
32
Oracle SQL Developer
Oracle
Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle. Run your sql and sql scripts, manage users, create and edit objects, import data to new or existing tables, diagnose performance issues, visualize your schemas, and much more. The power of your favorite desktop tool, in your browser. Available with Oracle REST Data Services for your on-premises instances. Migrate Oracle On-Premises to Oracle Cloud. Click, browse, and managed the contents of your Oracle Database. -
33
dbForge Data Compare for PostgreSQL is a GUI tool for table data comparison and synchronization. It helps to custom-tailor the detection of data differences between two PostgreSQL tables, establish smart management of inconsistencies and safe deployment of changes. This PostgreSQL diff tool also delivers the generation of the PostgreSQL data synchronization scripts with multiple options to keep your PostgreSQL data in sync. Key Features: *Compare, analyze and synchronize data in PostgreSQL databases Generate SQL scripts to migrate content between databases *Copy lookup data from development databases to staging or production *Keep an accurate history of all previous PostgreSQL database records *Restore missing or damaged data to a single row *Automate routine synchronization tasks from the command line *Operate with the latest versions of PostgreSQL and Amazon Redshift *Connect to IBM Cloud (via SSL) and Amazon AuroraStarting Price: $79.95
-
34
KS DB Merge Tools
KS DB Merge Tools
KS DB Merge Tools is an easy to use diff & merge tool for MySQL, MariaDB, Oracle Database, SQL Server, PostgreSQL, SQLite, MS Access and Cross-DBMS databases allowing to compare and sync both schema and data. Starting with a schema changes summary, results can be narrowed down to object lists of particular object type (table definitions, views, etc.), and then down to definition of particular object. Data changes can be retrieved as a high-level list of changes totals across all tables in the database, each total row count can be observed as a side-by-side list of rows for the given table, each changed row can be analyzed for changes in each column. Various diff results provide quick filters to show only new/changed/new+changed items (schema objects or table data rows), ability to select required changed items and generate scripts to apply these changes to the other side database. This script can be executed immediately or saved for future use.Starting Price: $50/user, volume discounts -
35
dbForge Data Compare for SQL Server is a specialized GUI-based tool designed to compare table data in SQL Server without the necessity to write code. Key Features: - Support for SQL Server tables, views, data in backups, data in script folders, SQL Azure Cloud, and custom queries - Direct results viewing with full-text data search, easy navigation, sorting, and filtering - Restoration of missing or damaged data down to a single row from native backups - Data synchronization through wizards, allowing for deployment of selected or all changes - Generation of data deployment scripts which can be executed directly or saved for recurring use - Deployment to SQL Server databases, SQL Azure cloud databases, and SQL Server on Amazon RDS - Automation of routine data comparison and synchronization tasks via a command-line interface dbForge Data Compare integrates with SQL Server Management Studio, enhancing its default functionality within a familiar interface.Starting Price: $219.95
-
36
MobiDB
Vitaliy Korney
No-code automation tool to manage business, work, hobby. Design custom databases, lists, collections, catalogues for specific needs. Create databases, forms, fields in the visual designer. MobiDB Database can be used for business purposes as well as personal needs. MobiDB enables multi-user access and cloud synchronization for iOS, Android and Windows. Design database and input forms using Visual form designer. Csv import enables data exchange between MobiDB and MS Access, Filemaker, Excel. Import entries from csv to create a new table or to the existing tables. Export created databases to PDF or print the entries. MobiDB is great Personal database organizer app as well as Business database app. MobiDB is a perfect suit for field workers, geological exploration. It supports Geo GPS coordinates and suits for geologists, archaeologists and etc. to track custom entries.Starting Price: $9.99 per year -
37
dbForge Data Pump
Devart
dbForge Data Pump for SQL Server is an add-in for SQL Server Management Studio (SSMS) that simplifies data migration in various formats, supporting both data import and export operations. Key Features: - Support for 10 data formats for import operations and 14 data formats for export operations - Configuration wizards for both import and export tasks - Direct import from third-party databases into SQL Server databases - Exporting full tables or specific records, exporting data into a single file or multiple files - Versatile options for data import - Configurable error-handling behavior - Saving task settings as templates for recurring tasks - Automation of data import and export via the command line The Data Pump tool enables users to configure and perform common data migration tasks using wizards for simple setup and saving settings for recurring tasks. It handles large data volumes efficiently, eliminating errors caused by manual input.Starting Price: $169.95 -
38
Analyze the performance of Greenplum DBMS using monitoring and query management tools in the command center, where you can also view and download query and session histories. Hybrid Storage in Yandex Managed Service for Greenplum® is natively integrated with Object Storage, allowing you to organize hybrid storage with automatic data transfers to cold storage. You can deploy a ready-to-use cluster in just a few minutes. DB settings are optimized for the selected cluster size and you can change them if necessary. Thanks to its integration with the DataLens BI system, build reports, charts, and dashboards, directly from the service, based on data stored in Greenplum. All DBMS connections are encrypted using the TLS protocol. Our infrastructure meets local regulatory, GDPR, industry-specific ISO standards, and PCI DSS security requirements.
-
39
Imply
Imply
Imply Cloud is a managed service for AWS. With Imply Cloud, you can explore and visualize large-scale activity streams without the need to build and manage your own infrastructure. Imply Cloud deploys nodes in a Virtual Private Cloud (VPC) running in your Amazon Web Services account. You own the cluster and the data. Leverage Imply Analytics to explore all of your event streams. Find root causes, compare ad hoc slices of data, and share insights with teammates. Directly connect BI tools such as Tableau, Zeppelin, Looker, etc. to your cluster. You have complete flexibility to choose the tools to use for reporting and dashboarding. You can also use SQL or direct Druid queries to build your own applications. -
40
CompareData
Zidsoft
Compare and synchronize sql data visually. CompareData allows you to visually compare and synchronize data between sql databases. Compare table, view or query data and see differences highlighted on the screen. Compare table metadata, generate sql sync script, use the command line and internal scheduling to automate comparison and data synchronization. • Compare data of table, query or group of tables. • Synchronize table data at row, table or group level. • Compare table metadata including columns, primary key, indices, foreign keys, triggers, permission and check constraints. • Compare stored procedures, functions and sequences, • Cross-dbms support with ODBC. • Compare resultsets of any size. • Native 64-bit application. • Multi-threaded, multi-core support. • Free for comparing data and metadata.Starting Price: $495 single user license -
41
SurrealDB
SurrealDB
SurrealDB offers a dynamic and adaptable platform for business. With an integrated suite of cutting-edge database solutions, tools, and services, SurrealDB empowers your workforce to discover innovative answers using products meticulously crafted to meet their requirements. The query language in SurrealDB looks and works similarly to traditional-SQL, but allows for querying over time-series and connected graph data. SurrealQL is an advanced query language, with programming language functionality, that allows developers or data analysts to work with SurrealDB in the ways they choose. Connect directly to SurrealDB from any end-user client device. Run SurrealQL queries directly within web-browsers, ensuring that users can only view or modify the data that they are allowed to access. Highly-performant WebSocket connections allow for efficient bi-directional queries, responses and notifications. -
42
SQLPilot
SQLPilot
Write your prompt in natural language, mention the tables required, and generate a query with the AI model of your choice. Add as many connections as you want. Supports autocomplete for SQL queries to speed up your workflow. We do not store your schemas, queries, or credentials. We only use the data you provide to us to generate SQL queries. Download your results in CSV format. View your results in graphs and charts. Experience the power of AI-powered SQL queries with our free plan. Quickly generate your complex SQL queries with the help of AI. SQLPilot is your AI-first SQL query tool to generate queries with all the context you need.Starting Price: $20 per month -
43
AutosyncDB
DreamTeam
AutosyncDB is a comprehensive solution for comparing and synchronizing SQL Server database schemas along with predefined data. The idea is to automate the database update for each new version of an application using its new database as a source of sample schema and predefined application data. In a few clicks AutosyncDB allows you to reveal the differences between database objects, analyze them, build your own customized synchronization script and deploy it. In addition, using the integration support you can run such a task for multiple databases on your servers, or export it as a package to provide client-side updates. -
44
SQL Server Data Tools (SSDT)
Microsoft
SQL Server Data Tools (SSDT) transforms database development by introducing a ubiquitous, declarative model that spans all the phases of database development inside Visual Studio. You can use SSDT Transact-SQL design capabilities to build, debug, maintain, and refactor databases. You can work with a database project, or directly with a connected database instance on or off-premise. Developers can use familiar Visual Studio tools for database development. Tools such as: code navigation, IntelliSense, language support that parallels what is available for C# and Visual Basic, platform-specific validation, debugging, and declarative editing in the Transact-SQL editor. SSDT also provides a visual Table Designer for creating and editing tables in either database projects or connected database instances. While you are working on your database projects in a team-based environment, you can use version control for all the files. -
45
Kal Admin
Kalrom Systems
There are different ways to cut IT department costs, but the most intelligent and profound way is by increasing employee productivity. Once you implement efficient work methods you pave the way for continuous saving and improvement. Kal Admin is an indispensable software for hundreds of Analysts, Developers, QAs and DBAs in the public service in Israel. Kal Admin's Data Dictionary is a repository where Business Analysts store definitions and descriptions of data elements required to satisfy end user requirement. Business terminology can be stored in the Dictionary as well. The Dictionary is used later for building tables in the database. Using Kal Admin, tables can be defined without actually building them in the database. Columns in the table are defined using the Data Dictionary. Once the defined tables pass quality assurance you can build them in the database with a click. -
46
dbForge Search
Devart
dbForge Search for SQL Server is a free tool that searches for specific SQL objects, data, and text across multiple databases. With a user-friendly graphical interface, it removes the need for manual inspection of entire database schemas and thus allows for significant time savings. Key Features: - Customizable search (searching for DDL or data) with options like case matching, whole-word matching, and wildcard support - Searching for database objects containing specific data - Simultaneous searches across multiple databases and object types - Name-based search within object names and bodies. - SQL code search for specific code fragments within database objects - Sorting, filtering, and grouping of search results - Search results in a grid format - Quick navigation to locate objects dbForge Search integrates seamlessly with SQL Server Management Studio, allowing users to perform all search operations and manage search results directly within the the SSMS.Starting Price: 0 -
47
Calligra
KDE
Calligra Suite is an office and graphic art suite by KDE. It is available for desktop PCs, tablet computers, and smartphones. It contains applications for word processing, spreadsheets, presentation, vector graphics, and editing databases. Calligra Words is an intuitive word processor application with desktop publishing features. With it, you can create informative and attractive documents with ease. Calligra Words makes adding images, charts etc to your documents effortless. It’s as simple as dragging it onto the document. Calligra Sheets is a fully-featured spreadsheet application. Use it to quickly create spreadsheets with formulas and charts, to calculate and organize your data. KEXI is a visual database applications creator. It can be used for designing database applications, inserting and editing data, performing queries, and processing data. Forms can be created to provide a custom interface to your data. -
48
ASKY
ASKY Software
ASKY - Database-like Power For Your CSV Files... Just Point-and-Click! Find & fix bad CSV data. Query. Get totals/avgs. Fast & easy! Database-like functionality... without the database hassles. ULTRA HIGH SPEED: ASKY flies through your large plain-text CSV data files thanks to optimized program code and design. EASY TO USE: Point-and-click easy - NO language or commands to learn. Just select your data files, a few settings, and click GO. POWERFUL: SQL databases?? Don't need them. Packed with tools, ASKY is industrial-strength. Work with UNLIMITED files/data size. Sift out the bad records from the good: Have data where the number of fields just don't line up? The SIFTER will separate out the bad stuff for you to straighten out. Fix them up: The UTILITIES section has specialized tools to move/replace data from one field to another, add/delete fields, and rearrange field order. Query it all: Use the point-and-click QUERY to pull records that meet your exact criteriaStarting Price: $79/year -
49
HyperSQL DataBase
The hsql Development Group
HSQLDB (HyperSQL DataBase) is the leading SQL relational database system written in Java. It offers a small, fast multithreaded and transactional database engine with in-memory and disk-based tables and supports embedded and server modes. It includes a powerful command line SQL tool and simple GUI query tools. HSQLDB supports the widest range of SQL Standard features seen in any open source database engine: SQL:2016 core language features and an extensive list of SQL:2016 optional features. It supports full Advanced ANSI-92 SQL with only two exceptions. Many extensions to the Standard, including syntax compatibility modes and features of other popular database engines, are also supported. -
50
phpMyAdmin
phpMyAdmin
phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement. phpMyAdmin comes with a wide range of documentation and users are welcome to update our wiki pages to share ideas and howtos for various operations. The phpMyAdmin team will try to help you if you face any problem; you can use a variety of support channels to get help. To ease usage to a wide range of people, phpMyAdmin is being translated into 72 languages and supports both LTR and RTL languages. Browse and drop databases, tables, views, fields and indexes. Create, copy, drop, rename and alter databases, tables, fields and indexes.