Best Database Clients for Linux - Page 2

QStudio is a free, modern SQL editor supporting over 30 databases, including MySQL, PostgreSQL, and DuckDB. It offers features such as server browsing for easy viewing of tables, variables, functions, and configuration settings; SQL syntax highlighting; code completion; the ability to query servers directly from the editor; and built-in charts for data visualization. QStudio runs on Windows, Mac, and Linux, providing particularly good support for kdb+, Parquet, PRQL, and DuckDB. Additional functionalities include data pivoting similar to Excel, exporting data to Excel or CSV, and AI-powered tools like Text2SQL for generating queries from plain English, Explain-My-Query for code walkthroughs, and Explain-My-Error for debugging assistance. Simply send the query you want and select the chart type to draw a chart. Send queries straight from within the editor to any of your servers. All data structures are handled perfectly.

DynoTable is a local-first DynamoDB GUI, a desktop client for Amazon DynamoDB on macOS (Apple Silicon), Windows and Linux (.deb/.rpm). Its SQL Workbench runs real SELECT queries with JOINs, GROUP BY and aggregations (SUM, AVG, COUNT DISTINCT, HAVING) over live tables. Every query previews its plan before it runs, showing Scan vs Query, the index and an RCU estimate, so you see the cost first. Smart Tables join tables on a primary key or any global secondary index and recompute live, with no schema migration or ETL. A built-in AI agent runs on your own Amazon Bedrock keys. It reads your schema, drafts queries and proposes writes, and no prompt, schema or row leaves your AWS account. Claude Code, Cursor and Codex connect over MCP. External agents never write directly; every change lands in a staging window you review and commit. DynoTable talks straight to AWS with your own credentials, so it can only do what your IAM policy allows, and works with AWS SSO, aws-vault and DynamoDB Local.

pgAdmin is a free software project released under the PostgreSQL/Artistic licence. The software is available in source and binary format from the PostgreSQL mirror network. Because compiling from source requires technical knowledge, we recommend installing binary packages whenever possible. pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world. pgAdmin is a management tool for PostgreSQL and derivative relational databases such as EnterpriseDB's EDB Advanced Server. It may be run either as a web or desktop application. As pgAdmin is a web application, it can only interact with the local filesystem in ways that are allowed by modern web browsers. This limits what is possible for security; essentially files can only be "downloaded" or "uploaded" (through a form).

A Powerful MySQL Development and Administration Solution. SQLyog Ultimate enables database developers, administrators, and architects to visually compare, optimize, and document schemas. SQLyog Ultimate includes a power tool to automate and schedule the synchronization of data between two MySQL hosts. Create the job definition file using the interactive wizard. The tool does not require any installation on the MySQL hosts. You can use any host to run the tool. SQLyog Ultimate includes a power tool to interactively synchronize data. Run the tool in attended mode to compare data from source and target before taking action. Using the intuitive display, compare data on source and target for every row to decide whether it should be synchronized in which direction. SQLyog Ultimate includes a power tool to interactively compare and synchronize schema. View the differences between tables, indexes, columns, and routines of two databases.

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.

Modern database administration tool. Cross-platform MySQL and PostgreSQL GUI with data grid, schema builder, and interactive charts. Datazenit is a web-based database administration tool. It features a smart data grid, query builder, schema editor, live charts, and raw query editor with auto-complete. The goal is to build a modern and intelligent database tool that would increase productivity. The schema editor has been designed with developer productivity in mind. It is equipped with intelligent features similar to the ones you could find in an IDE. Users can choose to query data via a graphical user interface instead of a classic raw query editor. Query builder supports multiple conditions, sorting and more. Various chart styles can be used to create effective visualizations, like scatter, line, area, bar, and pie chart. Best of all, they can be shared or embedded. Enjoy an advanced data grid with different editors like text area, dropdown, checkbox, and a calendar.

View data relations directly in the document. Mingo will recognize document references and shows you a preview or lets you open the document with one click. Save your time by minimizing clicks and operations to get your work done. Bring all your important data together in a high-level overview. Create your own dashboard with the data you want to see. Mingo’s Aggregator is here to help. With its visual UI, you get a great overview of what the pipeline does, what the results at each step are and whether you have any errors. As you type, Aggregator provides autocomplete options, checks code validity and loads sample results for each stage. This way you see the immediate results, knowing whether your code does what you are expecting. If you are not sure about the proper use of commands, quick links to documentation are available.

Mongrel is a desktop database systems workbench that unifies 30+ database engines, terminals, file transfer, containers, Kubernetes, and an API client in one native app for Windows, macOS, and Linux. Query PostgreSQL, MySQL, MongoDB, SQL Server, Oracle, Redis, ClickHouse, Snowflake, BigQuery, and more in native SQL or engine dialects. Edit data inline, drill through foreign keys, run EXPLAIN plans, design schemas on a visual ER canvas, sync data between databases, and schedule encrypted backups. Built-in SSH/Mosh/Telnet/Serial terminals, SFTP/SCP file transfer, Docker and Podman management, Kubernetes operations, and an HTTP/GraphQL/WebSocket/gRPC client replace a stack of tools. An opt-in AI assistant supports OpenAI-compatible, Anthropic, and Gemini providers, with keys in your OS keychain and writes always approval-gated. Mongrel is local-first: your queries, data, and logs never leave your machine. All plans include every feature; start with a 7-day trial, no card required.

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.

Available for all database objects such as Collections, Views, Functions, Indexes, GridFS, and MapReduce. Our professional object designer allows you to create, modify, and design database objects, all without writing a script. Navicat for MongoDB is designed to streamline your routine database tasks. The new interface is easy to access and understand -- giving you new ways to manage your MongoDB databases and making your work more efficient than ever. Available for all database objects such as Collections, Views, Functions, Indexes, GridFS, and MapReduce. Our professional object designer allows you to create, modify, and design database objects, all without writing a script.

MonjaDB is a GUI client tool for MongoDB developed by JUMPERZ.NET. On a single MongoDB node, you can browse your databases, collections and documents. Single documents can easily be created, edited or removed.

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.