SQL node
The SQL node helps you connect to your database and run queries to get the data you need — right inside Datastripes. No complicated setup, just tell it where your database lives, and what you want to ask.
What can it do?
- Connect to popular databases like MySQL, Postgres, Oracle, SQLite, and even MongoDB.
- Run your own SQL queries to fetch or filter data.
- Use the results right away in your data flows.
How to set it up
To connect your SQL node, you’ll need to provide some details about your database:
| What you need | What it means |
|---|---|
| Database type | Which database you use (Postgres, MySQL, etc.) |
| Host | The address of your database server (like db.example.com) |
| Port | The connection port (usually a number like 5432 or 3306) |
| Username | Your login name for the database |
| Password | Your database password |
| Database name | The specific database you want to access |
Running queries
Once connected, you simply type in the SQL query you want to run. For example:
SELECT * FROM customers WHERE country = 'USA';
The node will send this query to your database and bring back the results for you to use.
A quick example
Imagine you want to get recent sales from a Postgres database. You’d set it up like this:
- Database type:
postgres - Host:
db.postgres.example.com - Port:
5432 - Username:
datastripes_user - Password:
yourpassword - Database:
salesdb
Then, your query might look like:
SELECT order_id, total_amount FROM orders WHERE order_date > '2025-01-01';
Easy!
Use cases for the SQL node
The SQL node is super flexible and can help you with lots of data tasks, like:
- Sales reporting: Pull recent sales data from your company’s database to track performance and spot trends.
- Customer insights: Query customer info to understand buying habits or segment your audience.
- Inventory management: Check stock levels or reorder status in real time.
- Marketing campaigns: Analyze campaign results by querying clicks, conversions, and engagement data.
- Financial analysis: Get up-to-date financial figures, budgets, or expense reports directly from your finance system.
- Support tickets: Review and filter support cases by priority or status to stay on top of customer issues.
Basically, if your data lives in a database, the SQL node can help you bring it in, filter it, and turn it into clear insights — all without leaving Datastripes.
Tips for success
- Make sure your database details are correct — a typo can cause connection issues.
- Test your SQL query in a tool like pgAdmin or MySQL Workbench before using it here.
- Use simple queries at first, then build up as you get comfortable.
- Keep your password safe and don’t share it publicly.
Troubleshooting quick fix
If something isn’t working:
- Double-check your username, password, host, and port.
- Make sure your database allows connections from Datastripes.
- Look for error messages in the node and adjust your query if needed.
With the SQL node, bringing your data into Datastripes is smooth and straightforward — so you can focus on exploring insights, not wrestling with connections.