Own your Amazon data.
DataBrill Core saves your Amazon reports and data sets into one database, either on your own server or hosted by us. We keep the pipeline running, so you can use the data in your reporting tools and AI assistant.
-- View: daily orders per SKU (key columns). amazon_orders_by_day_and_sku ( local_date_first text, marketplace_id text, sku text, currency text, total_quantity_ordered integer, total_price numeric ); -- Table: daily ad cost per SKU (key columns). "amzagg_profit__adSkuDay" ( "date" date, "marketplaceId" text, sku text, "totalCost" double precision );
-- Top 10 SKUs by units sold, last 30 days. SELECT sku, SUM(total_quantity_ordered) AS units_sold, SUM(total_price) AS revenue FROM amazon_orders_by_day_and_sku WHERE local_date_first::date >= current_date - 30 AND marketplace_id = 'ATVPDKIKX0DER' GROUP BY sku ORDER BY units_sold DESC LIMIT 10;
| sku | units_sold | revenue |
|---|---|---|
| DB-SKU-00471 | 8,412 | 142,931.04 |
| DB-SKU-00133 | 6,902 | 98,440.18 |
| DB-SKU-00208 | 5,178 | 87,205.62 |
| DB-SKU-00059 | 4,815 | 71,290.55 |
| DB-SKU-00342 | 4,193 | 68,512.41 |
| DB-SKU-00917 | 3,847 | 54,331.79 |
| DB-SKU-00088 | 3,215 | 47,892.30 |
| DB-SKU-00610 | 2,950 | 41,067.84 |
| DB-SKU-00754 | 2,617 | 38,114.92 |
| DB-SKU-00021 | 2,344 | 29,608.51 |
Tired of being a data hostage?
Your data is trapped in rented dashboards and export files you have to piece together yourself.
A dashboard only lets you look at the numbers. A real database lets you work with them.
Your data should belong to you. Act like it.
Your data, your database, your rules.
Extract
- Automated pulls from Selling Partner and Advertising APIs.
- Orders, inventory, ads, settlements, performance.
- Historical backfill plus continuous incremental syncs.
- Token rotation, retries, schema versioning handled.
Own
- Data lands in your Postgres. Managed by us, or bring your own.
- Clean documented schema. No vendor lock-in.
- Per-workspace isolation.
- Raw S3 archive for re-derivation and audit.
Analyze
- Direct SQL access, with no rate limits and no fees per query.
- Connect Looker, Power BI, Metabase, Tableau.
- Point Claude, Cursor, or your own agent at the warehouse.
- Export to CSV any time. Feed any downstream system.
What lands in your database.
Documented, versioned, queryable. Same schema across managed Postgres and bring-your-own. Backfilled from your earliest SP-API access date.
-
amazon_
orders_ by_ day_ and_ sku local_date_first · merchant_id · marketplace_id · sku · asin · total_price
-
amazon_
sales_ and_ traffic date · merchant_id · marketplace_id · child_asin · sessions · units_ordered
-
amazon_
ads_ campaign merchant_id · marketplace_id · campaign_id · name · state · ad_product
-
amzreport_
SEARCH_ QUERY_ PERFORMANCE merchantId · marketplaceId · dateFirst · asin · searchQuery · searchQueryVolume
-
amzreport_
SEARCH_ CATALOG_ PERFORMANCE merchantId · marketplaceId · dateFirst · asin · impressionData · purchaseData
-
amzfact_
fnsku_ fbaInventory_ latest merchantId · marketplaceId · fnsku · asin · totalQuantity · fulfillableQuantity
| Table | Key columns |
|---|---|
| amazon_orders_by_day_and_sku | local_date_first · merchant_id · marketplace_id · sku · asin · total_price |
| amazon_sales_and_traffic | date · merchant_id · marketplace_id · child_asin · sessions · units_ordered |
| amazon_ads_campaign | merchant_id · marketplace_id · campaign_id · name · state · ad_product |
| amzreport_SEARCH_QUERY_PERFORMANCE | merchantId · marketplaceId · dateFirst · asin · searchQuery · searchQueryVolume |
| amzreport_SEARCH_CATALOG_PERFORMANCE | merchantId · marketplaceId · dateFirst · asin · impressionData · purchaseData |
| amzfact_fnsku_fbaInventory_latest | merchantId · marketplaceId · fnsku · asin · totalQuantity · fulfillableQuantity |
Plus 30+ more tables across SP-API, Advertising, Brand Analytics, and Search Query Performance. New report types ship continuously.
From signup to SQL in four steps.
- 01
Connect your Amazon account
Secure OAuth to Selling Partner and Advertising APIs. Usually done in about 15 minutes. We handle token rotation and renewals.
- 02
Choose your database
Use our managed Postgres or bring your own. Either way, the same pipeline fills it.
- 03
Data flows automatically
Scheduled syncs, historical backfill, real-time status. We run the pipeline; you use the data.
- 04
Query, analyze, export
Write SQL. Plug in Looker, Tableau, Metabase. Point Claude or Cursor at the warehouse. No per-query fees, no permission asked.
Built for teams that own their numbers.
Amazon-native brands
You've built a real business on Amazon. Get data infrastructure that matches.
Agencies and aggregators
Stop logging into ten dashboards. Keep each client's data in its own workspace.
Data teams
Postgres credentials and a documented schema to build on, with no vendor lock-in.
Enterprise
Talk to us about your deployment, procurement and usage requirements.
From report files to a queryable warehouse
Building reports from exported files means downloading, storing, and combining them yourself. DataBrill Core syncs your Amazon data into one database on a schedule, ready to query.
| Feature | With exported files | DataBrill Core |
|---|---|---|
| Collecting data | Download the files you need | Synced from Amazon on a schedule |
| Storage | Choose where to keep your files | A database we host, or one you already run |
| Querying | Prepare the files for analysis | Query the data directly, or through Claude and other agents |
| Reporting | Load the files into your reporting tool | Connect your reporting tool to the database |
| Custom analysis | Combine the files your question needs | Combine documented tables |
Questions, answered.
How is DataBrill Core different from account management services?
Account management services do operational tasks for you (updating listings, responding to buyers, managing ads). DataBrill Core is data infrastructure. We extract your Amazon data into your database so you can do whatever analysis and automation you want. Think of us as your data pipeline, not your operations team.
Can I use my own database?
Yes. On every tier you can connect a Postgres you already run: RDS, Supabase, Neon, your own VPC, whatever. We write into the schema you point us at and you keep the credentials. The pipeline is the same, the destination is yours.
What data does DataBrill Core extract?
Selling Partner API (orders, items, refunds, FBA, finances, returns), Advertising API (Sponsored Products, Brands, Display, campaigns, ad groups, keywords, placements), Brand Analytics, and Search Query Performance. We add report types continuously.
Do I need to be technical to use DataBrill Core?
For basic use, no. We handle the connection and syncs and you can export to CSV or connect Looker Studio in clicks. For advanced use (custom SQL, BI integrations), some SQL helps but isn't required. Many customers have their data team write queries while ops and finance just consume the results.
How is pricing structured?
Flat per-organization pricing. Unlimited marketplaces and merchant accounts at every tier. No seat tax, no per-order metering, no charges on the queries you run against your own database. See the pricing page for details.
What happens to my data if I cancel?
If you bring your own database, nothing happens. The data is already yours and stays put. If you're on managed Postgres, contact us before canceling and we'll help you move your data to a database you control.
Stop renting your own data.
Own it.
Your complete Amazon dataset in one Postgres.