Ready to run your first query in MightyDB? Let's do this! This guide assumes you've already installed MightyDB. If not, check out our Installation Guide first.
Step 1: Connect to a Database
Click the big friendly "New Connection" button in the top-left corner. You'll see a list of supported database types:
- PostgreSQL 🐘
- MySQL 🐬
- MongoDB 🍃
- SQLite 📦
- And more coming soon!
Select your database type and fill in the connection details. Don't worry—we'll guide you through each field with helpful tooltips.
Step 2: Write Your First Query
Once connected, you'll see our beautiful query editor with syntax highlighting, autocomplete, and all the goodies you expect from a modern SQL editor.
-- Try running a simple query
SELECT * FROM users LIMIT 10;Hit Cmd+Enter (or Ctrl+Enter on Windows/Linux) to run the query. Results appear instantly below!
Step 3: Explore the Features
Now that you've run your first query, let's explore what makes MightyDB mighty:
- Query History: Every query is saved. Go back in time whenever you need.
- Saved Queries: Bookmark your favorite queries for quick access.
- Share: Click the share button to send queries to teammates.
- Export: Download results as CSV, JSON, or Excel.
- Multiple Tabs: Work with multiple queries at once like a boss.
Pro Tips for New Users
- Use Cmd+K to open the command palette for quick actions.
- Right-click on tables to see quick actions.
- Star your favorite connections for easy access.
- Customize keyboard shortcuts in Settings.
- Enable auto-save in preferences—future you says thanks!
What's Next?
You're officially a MightyDB user! 🎉 Ready to dive deeper? Check out these guides next:
- Query Editor: Master all the editor features.
- Query Sharing: Learn how to collaborate with your team.
- Database Connections: Advanced connection options.