Pheri is a terminal-based user interface for MySQL. It allows you to connect to your MySQL databases and interact with them directly from your terminal — with a clean, minimal UI designed for productivity.

• Fast and Lightweight — Optimized for speed and responsiveness
• Navigate Tables — Explore your database schema easily
• Run Queries — Write and execute SQL queries directly
• View Results — Display result sets in a readable tabular format
• Keyboard Shortcuts — Perform common tasks with ease
• Cross-Platform — Works on Linux, macOS, and Windows

Terminals: Cmd Prompt, PowerShell, Windows Terminal, WSL, Bash, Zsh, Fish, Dash, Ksh, Tcsh, Terminal.app, iTerm2, Termux, BusyBox, Alacritty, Kitty, Tilda, Guake, Yakuake, Xonsh

The Search & Filter feature in Pheri enables users to quickly locate and interact with database objects such as tables, views, stored procedures, functions, and even entire databases.

Start typing into the search bar or command input area. The system supports filtered and unfiltered searches:

Typing a keyword without a filter prefix searches across all supported object types:

customer

This will return all tables, views, procedures, and functions that include the word customer.

Use the following format to filter by type:

<type>:<search-term>

• table:customer → Finds all tables with names containing customer.
• view:active → Filters views with active in the name.
• procedure:invoice → Searches stored procedures with invoice.
• function:calc → Searches user-defined functions with calc.
• db:sales → Lists databases that include sales in the name.

Once you select a result from the filtered list:

• Automatically runs:

  SELECT * FROM <name> LIMIT 100

• Displays results in a data grid.

• For tables, inline editing is enabled.

• Shows the definition using:

  SELECT routine_definition FROM INFORMATION_SCHEMA.ROUTINES ...

• Displays the output in a read-only query area.

• Switches to the selected database as the active working database.

• Case-insensitive search.
• Detects and separates the filter type and search keyword automatically.
• Dynamically updates the list view in real-time.

• If an error occurs during selection (e.g. query fails), a modal will be shown with the error message.
• Errors in table editing or fetching routine definitions are also handled and shown via dialog pop-ups.

This module provides an interactive Terminal User Interface (TUI) for exploring and interacting with MySQL databases.

• Select and switch between databases
• Browse tables, views, stored procedures, and functions
• View data from tables/views with a LIMIT of 100 rows
• Execute SQL queries with a query editor
• Edit table data (if supported)
• Maintain query history for reuse
• Keyboard shortcuts for navigation and execution

• Start the application.
• Use arrow keys to select a database from the list.
• Press Enter to activate the selected database.
• Errors (e.g., permission issues) are shown in a modal window.

• Navigate using arrow keys.
• Press Enter:
  • On a table/view: Displays the first 100 rows.
  • On a procedure/function: Shows the routine definition.

• Write SQL statements in the query editor.
• Press Ctrl+R to execute.
• Results are shown in the Data Viewer.

• Editing is supported only for tables, not views.
• Select a table, view its data, and enter edit mode.
• Edited values are committed back to the database.

• Each successful query is stored in a per-database history.
• Queries can be reloaded and reused later.

• All errors (database access, SQL issues, etc.) appear in a modal popup.
• Press the "OK" or "Back" button to continue.

Primary function: UseDatabase(app *tview.Application, db *sql.DB, dbName string)

• Switches database using USE dbName
• Fetches metadata via:
  • SHOW DATABASES
  • information_schema.tables
  • information_schema.routines
• Core components:
  • tview.List for databases/tables
  • tview.TextArea for query editing
  • tview.Table for displaying results
• Uses helper functions like ExeQueryToData(), ExecuteQuery(), EnableCellEditing()

Screenshot

Direct Command: .\pheri -u root -p 12345678 -host 127.0.0.1 -port 3306

Optional -host 127.0.0.1 -port 3306