Try it with your local Postgres DB, no signup needed
Replace your existing postgres
container with our image:
- Download latest binary from the releases page on Github
- Add to your
$PATH
schemamap init
Schemamap introspects your Postgres schema, giving you unprecedented control over your system's state.
Finally you can copy database records as easily as files, without any DDL changes.
Repeatable processes.
Data migrations have been historically ad-hoc 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 are considered. This way the feasibility of your data migrations is checked before even importing.
(De-)normalization.
Existing ETL tools only work for single tables. Schemamap.io can copy related records together automatically.
Secure by default.
Schemamap.io uses the least amount of database resources and permissions for each stage of your adoption. By default it cannot even modify your live tables, only preparing data migrations.
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 worry about servers.
Schema tracking & comparison.
Track your database schema along with constraints across environments (Local/CI/Staging/Prod) and see how it evolves. Easily spot differences, regardless of the platform or provider.
Pricing for every business
Use Schemamap.io free forever (with generous usage limits).
Pay only for the Postgres 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/bandwidth counted?
- You are only charged for megabytes of data that is loaded into the temporary tables during data migrations, rounded up.
- 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.