Help & Tutorials Center
Your official guide to mastering DB CommanderX™ for SQLite.
Welcome!
This guide is designed to help you navigate the features of DB CommanderX™ for SQLite. Whether you're opening your first database, running complex queries, or managing table structures, you'll find step-by-step instructions here. Below, you can jump directly to a topic that interests you.
Table of Contents
Opening an Existing Database
1. On the main screen, tap the "Open Database" button.
2. Use the file explorer to navigate to your database file's location on your device.
3. Select your database file (usually with a .db, .sqlite, or .sqlite3 extension).
4. If it's a standard database, it will open immediately. If the file is encrypted, a dialog will appear prompting you to enter the correct password. Our free version allows you to open and work with existing encrypted files.
Creating a New Database
A. Creating a Basic (Unencrypted) Database
1. On the main screen, tap the "Create New Database" button.
2. Enter your desired filename (e.g., `my_project.db`).
3. Tap the "Create" button. A new, empty database will be created and opened.
B. Creating a New Encrypted DatabasePRO
Creating a new, password-protected database from scratch is a premium feature. To unlock this ability, please see the PRO Features & Upgrades section below.
Once you have PRO access, the creation process is simple: when creating a new database, check the box for "Encrypt Database" and set a secure password.
Using the Query Editor
1. After opening a database, tap the "SQL" button/tab to enter the Query Editor.
2. Write your custom SQL commands in the editor. You can use pre-existing commands from your query history or create new ones.
3. With the Query Editor, you can run any command, including creating temporary or permanent Views using `CREATE VIEW...`.
4. Tap the "Run" (▶) icon to execute the query. Results will be displayed below.
Exporting & Backing Up Data
Exporting a Single Table
1. Open the table whose data you wish to export.
2. Tap the 3-dot overflow menu and select the "Export Table" option.
3. Choose your desired format (CSV, PDF, or TXT) and follow the prompts to save the file.
Backing Up the Entire Database
1. From the main screen (table list), tap the 3-dot overflow menu next to the database name and select "Backup Database".
2. For Free Users: You will be prompted to watch a short rewarded ad. After the ad finishes, you can save a full copy of your `.db` file to your device's storage.
3. For PRO UsersPRO: This ad-watching step is skipped, allowing you to save the backup immediately.
Quick Guides for Other Features
Advanced Search
To search for specific data across tables with conditions (`LIKE`, `BETWEEN`, `IN`, etc.), tap the "Search" button and build your search filter.
Adding a New Table
Tap the "Add Table" button after opening a database. You will be prompted to define a table name and fill in the attributes for each column (name, data type, etc.).
Modifying a Table
Warning
Always back up your .db file before altering an existing table's structure. See our disclaimer for more info.
To modify an existing table (e.g., add/drop a column), use the 3-dot overflow menu on the table list and select "Modify Table".
PRO Features & Upgrades
To access premium features like creating encrypted databases, you need PRO access. We offer two convenient options:
- Option 1 (Subscription): Tap the "Upgrade to PRO" button within the freemium app and choose a subscription plan (e.g., monthly). This unlocks all PRO features and removes ads.
- Option 2 (One-Time Purchase): For lifetime access with a single payment, purchase our separate standalone app, DB CommanderX™ PRO for SQLite, from the Google Play Store.
How to Remove Ads Only
If you only want to remove ads without getting PRO features, you can make a small, one-time purchase. Navigate to the Settings menu and tap the "Remove Ads" option. Please note this does not unlock PRO functionality.