GuideUpdated: April 2026

User Guide

Everything you need to get started with Hubba.Studio. From first connection to advanced features, this guide covers the complete database management workflow.

01. What is Hubba.Studio?

Hubba.Studio is a visual database editor for MySQL and MariaDB. It runs in your browser with zero installation required.

Think of it as a modern alternative to phpMyAdmin, with a clean interface and spreadsheet-style editing.

02. Getting Started

Connecting to Your Database

On the connect page, enter your database credentials. You can use a connection string format like this:

mysql://username:password@host:3306/database_name

Or fill in the fields manually: host, port, database name, username, and password. Either way works — choose whatever feels more natural to you.

Your First Session

After connecting, you'll land on the dashboard showing all your tables with their row counts and sizes. Click any table to view and edit its data. The interface is designed to be self-explanatory — explore around and you'll quickly get the hang of it.

Sessions expire after 30 minutes of inactivity for security. You can disconnect manually anytime using the disconnect button in the header.

03. Visual Editor

The visual editor is the heart of Hubba.Studio. It transforms your database tables into a spreadsheet-like interface where you can view, edit, and manage data without writing SQL. Click any table to open it, and you'll see your data laid out in rows and columns, just like Excel or Google Sheets.

Viewing Data

Navigate through large datasets using pagination controls. Search across all columns to find specific records quickly. Sort by clicking column headers to organize data however you need. The interface is designed to feel familiar — if you've used a spreadsheet, you already know how to use Hubba.Studio.

Editing Data

Click any cell to edit its value directly. Press Enter to save your changes, or Escape to cancel. Add new rows using the toolbar button, and delete rows by selecting them and confirming the action. Changes are sent to your database immediately, so you see results in real-time.

Export

Need to work with your data elsewhere? Export any table to Excel format with a single click. The export includes all visible columns and respects any filters you've applied, so you get exactly the data you need.

04. Table Management

Beyond editing data, Hubba.Studio lets you manage your database structure. Create new tables by defining their name, columns, data types, and constraints. Configure primary keys to ensure data integrity. The interface guides you through the process, making schema design accessible even if you're not a database expert.

Modifying Tables

Need to evolve your schema? Add or remove columns, change data types, and manage indexes without writing ALTER TABLE statements. The visual interface shows you what's possible and prevents common mistakes that could break your data.

Statistics

Every table shows key statistics: row counts, table sizes, and storage engine information. This helps you understand your database's footprint and identify tables that might need optimization or cleanup.

05. AI Assistant

The built-in AI Assistant is a smart helper for database analysis. It helps you understand your database structure without digging through documentation. It analyzes your schema, explains table relationships, answers questions about your database design, and provides optimization suggestions based on common patterns and best practices.

Current Limitations

The AI Assistant has read-only access to your schema information for database analysis. It cannot execute queries or modify data. We only send table and column names to the AI — never your actual data. This keeps your sensitive information private while still providing helpful guidance.

06. Security Best Practices

memoryIn-Memory Storage

Your database credentials are stored in memory only during your active session. Never written to disk or logs.

blockZero Persistence

When you disconnect or your session expires, all connection data is immediately destroyed.

visibility_offData Privacy

We never access your database content. Credentials are encrypted in transit. Direct connection between browser and database.

securityBest Practices

Use strong passwords. Disconnect when finished. Limit database user permissions. Use read-only credentials when only viewing.

07. Troubleshooting

Connection Issues

Can't connect? First, verify your host and credentials are correct. Make sure your database server is actually running and that your firewall allows connections from Hubba.Studio. Also confirm that the database user you're using has the necessary permissions to access the database.

Session Issues

Sessions automatically expire after 30 minutes of inactivity for security. If you get disconnected unexpectedly, just reconnect to establish a new session. You can also refresh the page to force a disconnect if something seems stuck.

Data Issues

If you can't edit or delete data, check that your database user has write permissions. Look for table locks that might be preventing changes. Review any database constraints (foreign keys, unique indexes) that could be blocking your operation. Error messages usually point you in the right direction.

Need Help? Contact us and we'll get back to you quickly.

Ready to Get Started?

Connect your database in seconds. No installation, no credit card, no setup.