Database Integration

​

Analyze Data Where It Lives

Connect PlotsAlot directly to your databases and analyze live data without exporting. Query, visualize, and share insights in real-time.

​

Supported Databases

More coming: Snowflake, Redshift, Supabase, Firebase

​

Quick Connection

​

One-Click Setup

Connecting to your database takes 2 minutes:

1. Provide Credentials

   • Host/Server address
   • Database name
   • Username and password
   • Optional: SSL certificate

2. Select Tables

   • Browse available tables
   • Preview data samples
   • Choose what to analyze

3. Start Analyzing

   • Query data naturally
   • Create visualizations
   • Share dashboards

​

Secure Connection

• Encrypted: All data encrypted in transit (SSL/TLS)
• No Storage: Data never stored in PlotsAlot
• Direct Query: Real-time access to your database
• Read-Only: Optional read-only connections for safety

​

How It Works

​

Connect Your Database

Establish a secure connection to any supported database. Credentials are encrypted and never exposed.

​

Browse Your Data

• See all available tables
• Preview table structures
• Check row counts
• Review sample data

​

Query Naturally

Use natural language to query your data:

• “Show me total sales by product category”
• “Compare revenue this quarter vs last year”
• “Find the top 10 customers by order value”
• “What’s the distribution of customer ages?”

​

Get Visualizations

Our AI interprets your query and:

• Writes efficient SQL
• Retrieves only necessary data
• Creates appropriate visualizations
• Formats results clearly

​

Share Results

Export or share dashboards connecting to live data.

​

Real-World Scenarios

​

Live Dashboard

Connect to your production database and create dashboards that update automatically with the latest data.

​

Sales Analytics

Query your CRM database directly to analyze pipelines, win rates, and forecast accuracy.

​

Customer Analytics

Understand customer behavior, retention, and lifetime value using live transaction data.

​

Operations Monitoring

Track inventory levels, order fulfillment, and operational metrics in real-time.

​

Financial Reporting

Analyze transaction data, expense reports, and budget performance from your accounting system.

​

Website Analytics

Query your application database to analyze user behavior and engagement metrics.

​

Security Features

​

Credential Encryption

• Military-Grade Encryption: AES-256 for credential storage
• No Plain Text: Credentials never logged or exposed
• Secure Retrieval: Credentials decrypted only for queries
• Regular Rotation: Change credentials anytime

​

Network Security

• SSL/TLS Encryption: All data encrypted in transit
• IP Whitelisting: Restrict access to your IP ranges
• VPN Support: Connect through private networks
• Firewall Friendly: Works behind corporate firewalls

​

Access Control

• Role-Based Access: Control who can access which databases
• Query Auditing: Log all queries and who ran them
• Read-Only Mode: Optional read-only connections
• Time-Limited Access: Revoke access immediately if needed

​

Compliance

• SOC 2 Type II: Audited security practices
• GDPR Compliant: Full data protection compliance
• HIPAA Ready: For healthcare organizations
• Data Residency: Choose where data stays

​

Advanced Querying

​

Natural Language Queries

Ask questions in plain English:

"Show me monthly revenue trends for the last 2 years"
"Which products have declining sales?"
"What's our customer churn rate?"
"Compare Q3 performance across regions"

​

SQL Queries

Use SQL directly for complex queries:

SELECT 
  DATE_TRUNC('month', order_date) as month,
  SUM(amount) as total_revenue,
  COUNT(DISTINCT customer_id) as customers
FROM orders
GROUP BY DATE_TRUNC('month', order_date)
ORDER BY month DESC

​

Scheduled Queries

• Run queries on a schedule
• Email results automatically
• Update dashboards periodically
• Monitor metrics continuously

​

Query Optimization

• Our AI writes efficient queries
• Automatic indexing recommendations
• Query performance analysis
• Caching for repeated queries

​

Data Refresh Options

​

Real-Time

• Query latest data instantly
• No caching or delays
• Best for dashboards
• Higher database load

​

Scheduled

• Refresh at specific times
• Daily, weekly, or monthly
• Lower database impact
• Slight delay in updates

​

On-Demand

• Refresh when you need it
• Manual control
• Minimal database load
• Best for large queries

​

Incremental

• Only fetch new/changed records
• Most efficient approach
• Requires proper timestamps
• Significantly reduces load

​

Limitations & Considerations

• Query Complexity: Very complex nested queries may need manual SQL
• Database Size: Very large tables may need filtering/sampling
• Network: Slow connections impact performance
• Credentials: Database credentials required (read-only option available)
• Privileges: Need appropriate database privileges for connections

​

Connection Troubleshooting

​

Connection Failed

• Verify host/port are correct
• Check username/password
• Ensure network access to server
• Check firewall rules
• Try from VPN if on corporate network

​

Too Slow

• Add indexes to queried columns
• Filter data to smaller date ranges
• Use sampling for large datasets
• Consider read replicas
• Enable query caching

​

Permission Errors

• Ensure user has SELECT privileges
• Check table-level permissions
• Verify schema access
• Contact database admin

​

SSL/Certificate Issues

• Verify SSL is enabled
• Upload correct certificate
• Check certificate expiration
• Try without SSL if needed

​

Best Practices

​

Security

1. ✓ Use read-only database accounts
2. ✓ Change passwords regularly
3. ✓ Use VPN for remote connections
4. ✓ Monitor query logs
5. ✗ Never share credentials
6. ✗ Don’t use production admin accounts

​

Performance

1. ✓ Create appropriate indexes
2. ✓ Filter large tables
3. ✓ Use scheduled refresh
4. ✓ Archive old data
5. ✗ Don’t query entire tables
6. ✗ Avoid complex joins on large tables

​

Data Quality

1. ✓ Validate data regularly
2. ✓ Use consistent date formats
3. ✓ Clean up duplicate records
4. ✓ Document data meanings
5. ✗ Don’t keep test data in production
6. ✗ Avoid NULL values

​

Integration with Other Features

​

Dashboard Creation

Connect to your database and create interactive dashboards showing live data.

​

PDF Analysis

Combine database data with PDF insights in comprehensive analyses.

​

Excel Export

Export database results as Excel files for offline analysis.

​

Sharing

Share database-connected dashboards with stakeholders.

​

Analytics

Track database connections and query performance in Google Analytics.

​

FAQ