MySQL + Orcabase
Your MySQL data, ready to ask about.
Orcabase copies the tables you pick from MySQL, MariaDB or Aurora into your warehouse on a schedule, so you can ask across them in plain words and join them with everything else you’ve connected.
- Built-in sync
- Syncs every 15 minutes to daily
- Only reads, never writes
What share of revenue came from subscriptions last month?
Subscriptions brought in 69% of August revenue: $33.4k of $48.2k.
- One-time orders made up the other $14.8k.
- The subscription share has grown every month since April.
- Sampler buyers are the biggest source of new subscribers.
Subscription share of revenue, %
How I got this· 4 steps
- Looked at your orders
- Split them into subscriptions and one-time
- Added up each by month
- Traced new subscribers to their first order
Example answer. Numbers are illustrative.
In plain words
How does Orcabase work with a MySQL database?
Orcabase signs in with a read-only login and copies the tables you choose into a warehouse it hosts for you, every 15 minutes to once a day. Each copy swaps in all at once, so charts never show half-loaded numbers.
Because the copy sits next to your other data, one question can cover your app’s orders and your spreadsheets or payments at the same time.
Ask in plain words
What you can ask about your MySQL data
The agent answers with the number, a chart and the steps it took. Keep the good answers on a dashboard.
How much did we sell yesterday, and how does it compare with last week?
Which customers order most often?
What share of orders use a discount code?
Which products run out of stock most often?
How many new accounts did we get each week this quarter?
Which cities do our customers come from?
What’s the average time between first and second order?
Show me refunds by reason for the last 90 days.
What comes in
Your MySQL data, ready to ask about.
A copy in a warehouse Orcabase hosts for you, refreshed in full on every sync.
The tables you pick
Tables added later
Types that make sense
A safe copy
Numbers worth defining
Define them once. Every answer agrees.
Tell Orcabase what each number means, certify it, and your dashboards, the agent and your whole team use the same one. The agent can draft these from your MySQL data.
Revenue
Paid orders minus refunds, by the day they were paid.
Orders per customer
Paid orders divided by the customers who placed them.
Discount rate
Share of orders that used a discount code.
Refund rate
Refunded amount as a share of revenue.
Dashboards to start with
Your MySQL numbers at a glance.
Ask the agent to build one of these, or pin charts yourself. Share any dashboard with a link.
Store overview
4 charts- Revenue by day
- Orders by product
- Discount rate
- Refunds by reason
Customers
4 charts- New customers by week
- Orders per customer
- Top cities
- Days to second order
Better together
Ask across MySQL and the rest of your business.
The best questions need more than one app. The agent can pull from several sources for one answer.
How to connect
Connect MySQL, step by step.
- 1
Create a read-only login
Two lines on your database give Orcabase a login that can only read. The MySQL guide has them.
- 2
Pick MySQL in Sync data
Go to Sync data → Add source and choose MySQL, under Built into Orcabase.
- 3
Connect
Enter the host, port, database and login, pick your warehouse under Sync into, and click Connect. Orcabase checks it can reach the database.
- 4
Choose tables and a schedule
Tick what to sync, choose how often, and click Start syncing. The first sync usually takes a couple of minutes.
What you’ll need
- The database’s host, port and name, and a read-only login.
- A database that accepts connections from the internet, or an allowlist we can be added to.
- The Admin role in Orcabase, and an Orcabase warehouse to sync into, part of data hosting.
- How it connects
- Built-in sync
- How fresh
- On your schedule: every 15 minutes to once a day.
- Where your data lives
- A copy in a warehouse Orcabase hosts for you, refreshed in full on every sync.
- Who can set it up
- An admin in your organization.
- Your login
- A read-only login you create. Its password is encrypted and never shown again.
- Cost
- No sync allowance to watch. The warehouse is part of data hosting, priced by storage.
Why is MySQL synced instead of read live?
Does it work with MariaDB and Amazon Aurora?
Anything to watch out for?
How fresh is my MySQL data in Orcabase?
Your MySQL data already has the answers.
Connect it, ask your first question, and pin the answers you want to see every week.