Docs

Quick start guide for using QueryPilot.

Quick start

  1. Create a connection profile for your MySQL server.
  2. Open the Query Runner.
  3. Write or paste SQL in the editor.
  4. Use Run Current or Run All.
  5. Tap any cell to copy its value. Long press to view full text.
  6. Export CSV or XML if your plan allows export.

Tips

  • Use read only credentials when possible.
  • Enable SSL when your server supports it.
  • Keep queries short and targeted for mobile.
  • Prefer SELECT and EXPLAIN when investigating.

Example queries

SELECT NOW();
SELECT DATABASE();
SHOW TABLES;
DESCRIBE your_table;
EXPLAIN SELECT * FROM your_table WHERE id = 123;
Place a screenshot here showing how QueryPilot highlights the current statement near the cursor.
Placeholder image: Screenshot showing how to create a connection profile in QueryPilot
Placeholder image: Screenshot of the query runner editor area
Placeholder image: Screenshot of the results table with sticky header