Try it locally, no signup needed
Replace your existing postgres
container with our image:
or apply to any existing Postgres DB:
Local-first DX
Schemamap.io is geared for developers who love using Postgres and know their way around SQL.
By using a handful of stored procedures, you can benefit from Schemamap.io without leaving psql or your favorite SQL client.
Spreadsheet management
Stop building CSV and Excel imports by hand. Allow your customers to import their data collaboratively for any table in your web app.
Tenant Onboarding
Track the onboarding progress of your tenants, see where people get stuck. Get notified on Slack when data is ready for import.
Postgres-native
Integrate Schemamap.io with any cloud Postgres provider (Supabase, Hasura, AWS RDS, GCP, Azure). No special extensions needed.
Always up-to-date
By tracking how the underlying tables & their constraints change, your spreadsheets stay automatically in sync. Trivially backfill data.
Everything you need to reduce your tenants activation time and to reduce churn.
Repeatable imports.
Spreadsheet imports have been historically one-and-done processes. Schemamap.io allows reruns and amendments, by handling the import process for you.
Automatic data validation.
All of your Postgres unique and check constraints get turned into their Excel-equivalent formulas and maintained as they change. Users get early feedback, before even importing.
(De-)normalization.
Existing tools only work for single tables. Schemamap.io uses the PostgreSQL analyzer to turn any SELECT with JOINs into an equivalent INSERT CTE.
SQL-defined interfaces.
Define how your multi-tenancy is implemented along with master data views in SQL via your regular database migrations. As close to the truth as it gets.
Secure by default.
Schemamap.io uses the least amount of database resources and permissions for each stage of your adoption. No fear of data leaks and your DBA stays in control.
In-memory transforms.
Schemamap.io never stores your data. It transfers it from and to your database in a heavily sandboxed environment, with tens of GBs of RAM readily available. So you don't have to.
Postgres-only.
Instead of building a generic solution, we are fully committed to building the best way to move tabular data in and out of Postgres. This allows us to provide the most secure and performant solution.
Schema analysis & diffing.
Track your database schema along with constraints across environments (Local/Staging/Prod) and see how it evolves. Easily spot any differences.
Localization support.
Schemamap.io supports your application locales (en_US, de_DE, fr_FR, ...). Provide your I18n as JSON, get tenant language specific columns/comments/dropdowns automatically, same as your frontend.
Pricing for every business
Use Schemamap.io free forever (with generous usage limits).
Pay only for the synced Postgres master data bandwidth used, per MB.
All prices include a -50% early adopter discount, upgrade while it lasts!
Free Plan
Starter Plan
€600/year
Pricing example
A usual 10K line row Product table with 40 columns is about ~1MB of data.
This allows 10X, 1024X, 10240x imports of this data for the Free, Starter and Pro plans respectively.
Want to know more with your own data?
Copy this SQL SELECT query and run it on your database to get a feel for which plan is right for you!
Frequently asked questions
- How does Schemamap.io not corrupt my Postgres database?
- By assuming all data migrations are faulty by default, and using safe-guards every step of the way. One example is not directly inserting/updating data, but instead using temporary tables to stage the data. This allows full control for introspection and validation and committing the data only when everything is in order.
- I've had performance issues with my DBs in the past, won't this make it worse?
- There are IOPS and record/second limiters built-in, allowing you to control the amount of data that is being processed at any given time. This leaves headroom for your application to continue running smoothly.
- How is the MB/bandwith counted?
- You are only charged for megabytes of data that is loaded into the temporary tables during data migrations. In case a DB-to-DB data migration, only the ingress data is charged.
- Is Schemamap.io GDPR compliant?
- Yes, Schemamap.io is GDPR compliant as it is a data processor, hosted in Germany. We do not store any data to disk during data migrations, only acting as a data-proxy, connecting your Postgres DBs and external sources.