Data Tools

Tablen includes a comprehensive set of data tools for profiling, comparing, generating test data, maintaining tables, managing processes, and administering database users.

Data Profiling

Analyze column statistics and data distributions:

Accessing Data Profiling

• Right-click a table in the sidebar and select "Data Profiling"
• Choose profiling mode (single table or column-level)

Profiling Metrics

For each column, data profiling computes:

• Row count: Total number of rows
• Null count and percentage: How many values are NULL
• Distinct count: Number of unique values
• Min/Max values: Range of values
• Average and standard deviation: For numeric columns
• Top values: Most frequent values with counts
• Data type distribution: Actual types present in the data

Use Cases

• Understand data quality before queries
• Identify columns with high null rates
• Find potential join columns based on cardinality
• Detect data anomalies

Data Compare

Compare data between two tables:

Accessing Data Compare

• Available as a dedicated tab type
• Compare tables across different connections

Compare Features

• Side-by-side comparison of two tables
• Highlights added, removed, and modified rows
• Compare by primary key or custom key columns
• Export differences

Mock Data Generation

Generate realistic test data for your tables:

Accessing Mock Data

• Right-click a table and select "Generate Mock Data"
• Or access from the Data Tools menu

Mock Data Features

• Generates data respecting column types and constraints
• Configurable number of rows
• Supports common data patterns:
  • Names, emails, addresses
  • Dates, timestamps
  • Numbers, currencies
  • Custom patterns
• Respects foreign key relationships
• Preview generated data before inserting

How to Use

1. Select the target table
2. Configure the number of rows
3. Review column configurations
4. Preview the generated data
5. Insert into the database

Table Maintenance

Perform maintenance operations on database tables:

Accessing Table Maintenance

• Right-click a table in the sidebar
• Select "Table Maintenance"

Maintenance Operations

Operations vary by database type:

PostgreSQL/MySQL:

• VACUUM (PostgreSQL) / OPTIMIZE (MySQL)
• ANALYZE -- Update table statistics
• REINDEX -- Rebuild indexes
• CHECK TABLE (MySQL) -- Verify table integrity

SQLite:

• VACUUM -- Rebuild database file
• ANALYZE -- Update statistics
• INTEGRITY_CHECK -- Verify database integrity

When to Use

• After large bulk deletes or updates
• When queries become slower over time
• After schema changes
• As part of regular database maintenance

Process List Viewer

Monitor active database processes:

Accessing Process List

• Right-click a connection and select "Process List"
• Opens as a dedicated tab type

Process List Features

• View all active connections and queries
• See query execution time
• Identify long-running queries
• Kill problematic processes (with confirmation)
• Auto-refresh at configurable intervals

Displayed Information

User Management

Administer database users and permissions:

Accessing User Management

• Available as a dedicated tab type
• Requires appropriate database privileges

User Management Features

• View existing database users
• Create new users
• Modify user permissions
• Grant/revoke privileges
• Reset passwords
• Drop users

Role-Based Access

User management operations respect your database role:

• Superuser/admin: Full access to all user management
• Regular user: Limited to viewing (if permitted by the database)

Keyboard Shortcuts