Documentation
Getting Started
Welcome to QueryHub! This guide will help you get started with our AI-powered database query assistant. QueryHub allows you to interact with your PostgreSQL database using natural language instead of complex SQL.
Quick Start Guide
- Sign up for an account - Create your free account to get started with QueryHub.
- Connect your database - Add your PostgreSQL database connection details.
- Start asking questions - Use natural language to query your database.
Connecting Your Database
To connect your PostgreSQL database to QueryHub, you'll need to provide a connection string in the following format:
Where:
- username - Your database username
- password - Your database password
- host - The hostname or IP address of your database server
- port - The port number (default is 5432 for PostgreSQL)
- database - The name of your database
Security Note
All database credentials are encrypted using AES-256-CBC encryption with unique initialization vectors. We do not permanently store your database content or query results.
Connection Steps
- Navigate to the Connections page in your dashboard
- Click "Add Connection"
- Enter a name for your connection
- Enter your PostgreSQL connection string
- Save your connection
Important Note
Local database connections (using localhost or 127.0.0.1) are not supported. Please use a remote database or a cloud-hosted PostgreSQL instance.
Using Natural Language Queries
QueryHub allows you to interact with your database using plain English. Here are some examples of questions you can ask:
Basic Queries
- Show me all users
- How many orders do we have?
- List the top 5 products by price
Advanced Queries
- Show me customers who made a purchase last month
- What's the average order value by category?
- Find products with low inventory
Query Tips
- Be specific about what information you need
- Mention table names if you know them
- You can ask for explanations of the generated SQL
- Request visualizations for data that would benefit from charts
Managing Your Queries
QueryHub allows you to save and organize your most important queries for future use.
Saving Queries
After running a query, click the "Save" button to store it for future use. You can:
- Give your query a descriptive name
- Add tags for better organization
- Add notes to explain the query's purpose
Account Management
Free vs Pro Plan
| Feature | Free | Pro ($8/month) |
|---|---|---|
| Database connections | 1 | Unlimited |
| AI queries per month | 10 | Unlimited |
| Natural language to SQL | ✅ | ✅ |
| Query management | Basic | Advanced |
| Data visualization | ❌ | ✅ |
| Export results | ❌ | CSV/JSON |
| Priority support | ❌ | ✅ |
No Credit Card Required for Free Tier
Start exploring QueryHub with our free tier - no credit card required. Upgrade to Pro anytime to unlock all features.
Troubleshooting
Common Issues
Connection Problems
If you're having trouble connecting to your database, check:
- Database credentials are correct
- Database server is accessible from external connections
- Firewall settings allow connections from QueryHub
Query Accuracy
If the AI isn't generating the expected queries:
- Try being more specific in your question
- Include table names if you know them
- Break complex questions into simpler ones
Getting Help
If you need additional assistance, we're here to help:
- Email Support: support@queryhub.ai
- Documentation: This guide and our blog articles
- Community: Coming soon - join our Discord community