Skip to main content

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
);
						

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.

01

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.
02

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.
03

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

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.

  1. 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.

  2. 02

    Choose your database

    Use our managed Postgres or bring your own. Either way, the same pipeline fills it.

  3. 03

    Data flows automatically

    Scheduled syncs, historical backfill, real-time status. We run the pipeline; you use the data.

  4. 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.

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.