← Back to blog
·The Mappt team

Connect your data sources: Postgres, ClickHouse, and APIs

Uploading a file is a great way to start a map. But a file is a snapshot - the moment you export it, it is already going stale. Your orders table keeps filling up, your sensors keep reporting, the API behind your dashboard keeps changing. Until now, keeping a map current meant exporting and re-uploading, over and over.

Today that changes. You can connect Mappt directly to the systems where your data already lives, and let your layers stay in sync on their own.

What you can connect

  • PostgreSQL / PostGIS. Point Mappt at a table, pick your geometry column (or latitude and longitude columns), and it renders - points, lines, polygons, choropleths.
  • ClickHouse. Turn billions of analytical rows into aggregated points and choropleths, straight from your warehouse.
  • REST APIs. Any endpoint that returns GeoJSON or JSON records. Add an API key or bearer token if it needs one, tell Mappt where the coordinates are, and it maps the response.

Connect once, build many

A data source is a reusable connection. You add it once - host, database, and credentials, or an API URL and key - and test it before you save, so you know it works. From there, every layer you build can draw from it, and updating the source updates the maps built on it.

Your map stays fresh

Each layer keeps its own sync. Hit Refresh now whenever you want the latest, or set an interval - every 15 minutes, hourly, daily - and Mappt re-pulls in the background. The layer updates in place; your styling, widgets, and shared views stay exactly as you left them.

Safe by default

Connecting a production database should not feel risky, so we built the guardrails in:

  • Your credentials are encrypted at rest and never sent back to the browser.
  • Every query Mappt runs is read-only, with strict timeouts and row caps - it can read your data, never change it.
  • Mappt assembles the queries from the table and columns you choose; your connection and secrets stay server-side.

What you need

API sources are available on Starter and up. Database sources - PostgreSQL/PostGIS and ClickHouse - are available on Pro and up. Uploading files is, and always will be, free.

Try it

Open the Sources panel, add a connection, and build a layer on top of it. The map you make today will still be right tomorrow - without you touching it.

Connect your data sources: Postgres, ClickHouse, and APIs