Connecting your DB is a first step to use Statsbot with SQL integration.
Currently Statsbot supports Redshift, Postgres, MySQL, BigQuery, SQL Server and Oracle.
To get started:
- Whitelist Statsbot IP (184.108.40.206) in your DB
- Sign in to Statsbot and press on Data Sources → Add Source
3. Select SQL icon
4. Start filling out the form by choosing your DB type and entering your DB name, DB Host, Port, Login and Password and hit the save button. If you experience any problems feel free to ping us in our support chat at the bottom right corner.
5. Hit the Save Button and you are all set.
We also support SSH connections.
Read this article to learn how you could write queries in your SQL editor