Mobile Docs

Getting Started

Download & Installation

LunoDB Mobile is available for free on the Apple App Store. Simply search for "LunoDB" or follow the direct link. Android support is coming soon.

First Connection Setup

Setting up your first database connection is simple:

1. Open LunoDB Mobile and tap "Add Connection"
2. Select your database type (MySQL, PostgreSQL, MariaDB, MongoDB, SQLite, or Turso)
3. Enter your connection details (varies by database type)
4. For remote databases, LunoDB Cloud establishes a secure connection
5. Start browsing your database!

Requirements

Biometric Security

LunoDB Mobile supports biometric authentication to protect your database connections. Enable Face ID or Touch ID on iOS, or fingerprint authentication on Android, to require biometric verification before accessing the app. Configure app lock timeout in Settings to automatically lock the app after a period of inactivity. When app lock is enabled, a privacy screen hides your data in the app switcher so others can't see sensitive information when switching between apps.

Database Support

Supported Databases

Turso Setup

Turso is an edge SQLite database that connects directly from the mobile app via HTTPS (no proxy required):

1. Create a database at turso.tech
2. Copy your database URL (e.g., libsql://your-db.turso.io)
3. Generate an auth token in the Turso dashboard
4. In LunoDB Mobile, select Turso and paste your URL and token

SQLite File Import

Import existing SQLite database files directly into LunoDB Mobile:

1. When adding a SQLite connection, tap "Import Database File"
2. Select a .db, .sqlite, or .sqlite3 file from your device or cloud storage
3. The file is copied to the app's secure storage
4. Your database is ready to use - no server required!

Coming Soon

We're working on adding support for:

• Redis (key-value browsing)

AI Features

LunoDB Mobile includes powerful AI features that let you interact with your database using natural language. Simply describe what you want in plain English, and the AI will generate the appropriate SQL query.

Setting Up API Keys

To use AI features, you'll need an API key from one of our supported providers:

AI SQL Generation

Type natural language queries like:

• "Show me all orders from last week"
• "Find users who haven't logged in for 30 days"
• "Get the top 10 products by sales"

The AI understands your database schema and generates valid SQL that you can review before executing.

AI-Powered Filtering

When browsing table data, use the AI filter to describe what you're looking for. For example, "premium customers from California" will automatically create the appropriate filter conditions.

Data Management

Viewing Table Data

Browse your tables with an intuitive mobile interface. Swipe horizontally to see more columns, pull down to refresh, and tap any row for details.

Filtering and Sorting

Use the visual filter builder to create complex conditions, or let AI build filters from natural language. Sort by any column with a single tap.

Inline Editing

Edit data directly in the table view. Tap a cell to modify it, and LunoDB will validate your changes before saving. Primary keys are protected from accidental modification. Use undo/redo to revert changes before committing, and preview all pending modifications before saving to the database.

Export Options

Export your query results or table data to:

• CSV - For spreadsheets and data analysis
• JSON - For APIs and applications
• SQL - INSERT statements for backup or migration

Advanced Features

Charts, Graphs & Home Screen Widgets

Visualize your data with interactive charts. Run a query and switch to chart view to see bar charts, line graphs, pie charts, and more. Pin your favorite charts as home screen widgets for instant access to key metrics without opening the app.

ER Diagrams

View your database schema as an entity-relationship diagram. See table relationships, foreign keys, and understand your data structure visually.

QR Code Sync from Desktop

Already using LunoDB on desktop? Scan a QR code to instantly import your connections to mobile. No manual setup required - all connection details transfer securely, including Turso databases and saved graphs.

1. Open LunoDB desktop and go to Settings → Export to Mobile
2. Click "Generate QR Code" to create a secure transfer session
3. Open LunoDB Mobile and tap "Scan QR" on the connections screen
4. Scan the QR code - all connections and graphs imported!

Deep Links

Open specific connections and databases directly using deep links. Share links with your team or save them as shortcuts to jump straight to the database you need.

Query History

Access your recent queries anytime. Search through your history to find and re-run previous queries. Save frequently used queries as favorites for quick access.

LunoDB Cloud

How It Works

1. You enter your database credentials in LunoDB Mobile
2. Credentials are encrypted and stored securely on your device
3. When you connect, LunoDB Cloud creates a secure tunnel to your database
4. Your queries travel through an encrypted connection
5. Results are returned directly to your device

Security & Privacy

• Your database credentials are never stored on our servers
• All connections use TLS 1.3 encryption
• Your actual data never passes through our infrastructure
• Connections are established per-session and don't persist

Limitations

LunoDB Mobile is designed for on-the-go database access. Some features from the desktop version have limitations on mobile: