SQLus Documentation

Installation

Get started with SQLus in minutes. Choose your preferred installation method:

Web Application

SQLus is a web-based application that runs directly in your browser. No downloads, installations, or setup required - just sign up and start querying your databases instantly.

No installation required

Works on any device with a browser

Automatic updates

Secure cloud-based platform

Getting Started

Simply visit our website, create a free account, and you'll be ready to connect your first database in minutes.

Get Started Now

Quick Start

Get up and running with SQLus in 3 simple steps:

1

Create Account

Sign up for a free SQLus account to get started.

2

Connect Database

Add your database connection details securely.

3

Ask Questions

Start querying your data in natural language.

PostgreSQL Setup

Connect your PostgreSQL database to SQLus with these configuration options:

SQLus

Connection Parameters

Host

Port

Database

Username

Password

Security Best Practices

Use read-only database users
Enable SSL/TLS encryption
Restrict network access with firewall rules
Use strong, unique passwords

Query Patterns

Learn the most effective ways to ask questions in natural language:

Aggregation Queries

"Show me total sales by month"

SELECT MONTH(date), SUM(amount) FROM sales GROUP BY MONTH(date)

"What's the average order value?"

SELECT AVG(total) FROM orders

"Count customers by region"

SELECT region, COUNT(*) FROM customers GROUP BY region

Filtering Queries

"Show orders from last week"

SELECT * FROM orders WHERE date >= DATE_SUB(NOW(), INTERVAL 1 WEEK)

"Find customers in California"

SELECT * FROM customers WHERE state = 'California'

"Products with price over $100"

SELECT * FROM products WHERE price > 100

Join Queries

"Show customer names with their orders"

SELECT c.name, o.* FROM customers c JOIN orders o ON c.id = o.customer_id

"Products and their categories"

SELECT p.name, c.category FROM products p JOIN categories c ON p.category_id = c.id

Chart Types

SQLus automatically suggests the best visualization for your data, but you can also choose manually:

Bar Charts

Perfect for comparing categories or showing changes over time.

Sales by Region Monthly Revenue

Pie Charts

Show proportions and percentages of a whole dataset.

Market Share Category Distribution

Line Charts

Track trends and changes over continuous periods.

Growth Trends Time Series

Name

Value

Item 1

$100

Item 2

$200

Data Tables

Display detailed data with sorting and filtering options.

Customer Lists Transaction Details

Security & Privacy

SQLus takes your data security and privacy seriously. Here's how we protect your information:

Encrypted Connections

All database connections use SSL/TLS encryption to protect your data in transit. We never store your database credentials in plain text.

Read-Only Access

SQLus only requires read-only access to your databases. We cannot modify, delete, or alter your data in any way.

No Data Storage

We don't store your actual database data on our servers. Query results are processed in real-time and not retained.

Access Controls

Implement proper user permissions and database access controls. Use dedicated read-only database users for SQLus connections.

Recommended Security Practices

Create dedicated read-only database users

Use strong, unique passwords

Enable database firewall rules

Monitor database access logs

Regularly rotate database credentials

Use VPN for additional security

Troubleshooting

Common issues and their solutions:

Can't connect to my database

Check these common issues:

Verify your database credentials are correct
Ensure your database server is running and accessible
Check firewall settings and network connectivity
Confirm the database port is open and correct

SQLus doesn't understand my question

Try these approaches:

Use simpler, more direct language
Be specific about table and column names
Break complex questions into smaller parts
Check our query pattern examples for guidance

Query results look incorrect

Verify the following:

Check if your question was interpreted correctly
Review the generated SQL query
Ensure your database schema is up to date
Verify data types and relationships

Tips & Tricks

Get the most out of SQLus with these helpful tips:

Be Specific

Use exact table and column names when possible. Instead of "sales data," try "sales table" or "revenue column."

Date Ranges

Use natural date expressions like "last month," "this year," or "past 30 days" for time-based queries.

Filtering

Combine multiple conditions: "Show customers in California with orders over $1000 from last quarter."

Aggregations

Use words like "total," "average," "count," "sum," and "group by" for aggregate queries.

Iterate

Start with simple questions and build complexity. Use follow-up questions to drill down into results.

Save Favorites

Bookmark frequently used queries for quick access. Build a library of your most common questions.