TablePlus/TablePlus

Features

• SQL Database Management - Provides a comprehensive graphical interface for administering relational and NoSQL database instances.
• Staged Change Commitments - Features a staged-change commit system that buffers GUI edits for review before executing them as SQL.
• Column Management - Provides comprehensive operations for creating, modifying, and removing columns within a table structure.
• Database Administration Tools - Serves as a professional workspace for performing administrative tasks across multiple database engines.
• Secure Connectivity - Establishes secure, encrypted connections to remote servers via SSH tunneling and native protocols.
• Database Index Management - Provides tools for creating and managing indexes to optimize query performance and retrieval speeds.
• Database Connection Configurations - Provides comprehensive database connection configurations supporting credentials, URLs, and SSH tunneling.
• Table Schemas - Provides a graphical interface for defining and modifying structured database table schemas.
• Table Metadata Inspection - Enables detailed inspection of table architectural definitions, including columns and data types.
• Database Object Browsers - Provides a sidebar interface for browsing and inspecting tables, views, functions, and procedures.
• Table Record Browsers - Provides a visual browser for exploring and editing records within database tables.
• Spreadsheet-Like Editors - Offers a spreadsheet-like interface for exploring database objects and editing records inline.
• Database User Privilege Management - Assigns global and database-specific access rights to control user permissions on data and operations.
• Inline Data Editing - Enables modifying database records directly within a tabular interface using a spreadsheet-like grid.
• Binary Protocol Implementations - Utilizes binary protocol implementations for low-latency, native communication with various database engines.
• Database Object Quick-Open - Enables rapid location and opening of databases, tables, and views via a global quick-open search interface.
• SQL Query Editors - Features a native SQL editor with auto-completion, formatting, and result visualization.
• Table Creations - Provides operations for building new database tables by defining fields, keys, and storage attributes.
• Table Deletions - Provides the ability to permanently remove a table and all its associated data from the database.
• Code Completion - Predicts and completes names of databases, tables, and columns while typing to accelerate SQL authoring.
• Database Management GUIs - Functions as a professional desktop GUI for managing relational and NoSQL database systems.
• Database Schema Lifecycle Management - Enables creating, renaming, and deleting databases within a connection, including specifying encoding and collation.
• Database SSH Tunnelers - Provides database SSH tunnelers to securely route traffic to remote servers via jump hosts.
• SSH Tunneling - Establishes secure, encrypted connections to databases using SSH tunneling and private keys.
• Database User Account Managers - Provides a graphical interface for creating and administering database user accounts and passwords.
• AI Query Generators - Uses a language model to generate SQL queries based on the database's table and view structures.
• Query Execution Logs - Records all executed SQL statements and their results to allow review of the exact traffic sent to the server.
• CSV Imports - Facilitates importing data from CSV files directly into existing database tables.
• Cursor-Based Pagination - Provides cursor-based pagination to retrieve large datasets in memory-efficient chunks.
• Grid Data Filters - Provides interactive grid filters to isolate records based on custom row and column expressions.
• Query Result Exporters - Exports the results of SQL queries into portable formats including CSV, JSON, and SQL.
• Database Backup and Restore - Supports exporting database contents to dump files and importing them for recovery or transfer.
• Database Backups and Restores - Provides tools for exporting database structures and data to dump files and restoring them for recovery.
• Connection Groupings - Allows categorizing multiple database connections into named groups to simplify project management.
• URL-Based Connections - Supports creating database connections using standardized URL strings for rapid setup and reuse.
• Dynamic SQL Query Executions - Supports dynamic SQL query executions by prompting for user-defined variables before submission.
• Query Favorites - Saves frequently used SQL queries with custom names and shorthand keywords for rapid retrieval.
• Hierarchical Organization - Organizes favorite queries into a hierarchical folder structure for managing reusable code libraries.
• Dynamic Connection Switching - Enables dynamic connection switching to change the active database context within an open session.
• Database Trigger Management - Provides a visual interface to create and manage database triggers for automation.
• Object Navigation Indexes - Maintains an in-memory object navigation index for rapid database schema exploration via fuzzy search.
• Virtual View Management - Allows the creation and management of virtual tables based on SQL queries.
• Query Cancellations - Allows users to terminate active database operations midway through execution using protocol-level signals.
• Concurrent Result Tabs - Displays the output of multiple concurrent SQL queries in individual tabs to keep result sets organized.
• Query Timeouts - Automatically terminates queries that exceed a specified time window to prevent hanging database processes.
• Dynamic Parameterization - Uses customizable regular expressions to prompt for variable values within queries before execution.
• Formatting and Beautification - Includes built-in tools to rearrange and clean up SQL statements for better readability.
• Stored Procedure Management - Provides a SQL editor and commit workflow to create, edit, and delete database functions and procedures.
• Incremental Result Streams - Displays data incrementally as it arrives from the database server to avoid blocking the UI.
• Table Data Export - Allows exporting selected table data to formats such as CSV, JSON, Markdown, and SQL insert statements.
• SQL Charting - Generates bar charts, line charts, and data tables directly from SQL query results for performance monitoring.
• Asynchronous Database Result Streams - Implements asynchronous database result streams to keep the interface responsive while loading large datasets.
• Bulk Record Updates - Provides the ability to modify values across multiple selected rows simultaneously for mass content editing.
• Interactive Session Recovery - Automatically restores queries and editor state from the previous session to resume work.
• Session State Restorations - Resumes active database connections and open tabs from the previous session upon launch.
• SQL Change Previews - Provides a visual review of generated SQL statements before they are committed to the database server.
• Local GUI Change Reversions - Cancels pending modifications made through the graphical interface before they are committed to the server.
• Workspace Managers - Allows users to organize and switch rapidly between multiple open database connections and environments.
• Query Safety Configurations - Configures the level of warnings and password prompts required before sending queries to the server.
• Query Execution Authentication - Mandates password or biometric authentication before executing queries to prevent unauthorized modifications.
• Sensitive Action Confirmations - Requires credential re-verification before performing high-risk destructive operations to prevent accidental data loss.
• Query History Logs - Logs all submitted queries locally to allow users to easily retrieve, reuse, or save statements.
• Interactive Dashboards - Builds interactive displays that link input fields to query parameters for dynamic data filtering.
• Database GUIs - Modern native GUI for relational databases.

Star 历史