Automation guide · Private preview
Connect DataMCP to Zapier
Read or change rows in a database connected to DataMCP without giving Zapier your database password. The Zapier integration is currently in private preview and is not yet searchable in the public app directory.
- 1
Connect a database in DataMCP
Add a PostgreSQL or MySQL source in your DataMCP dashboard and make sure its status is active. A private PostgreSQL on EC2 or a VPS also needs a running Local Agent Tunnel. You do not need to create an MCP link for this Zapier integration.
- 2
Create an Integration key
Open API Keys in your DataMCP dashboard and choose Create integration key. Select the source and only the operations your Zap needs. For writes, select the allowed table. Copy the secret when it appears: it is shown only once. A workspace API key, agent token, or database password will not work here.
- 3
Add DataMCP to your Zap
Create a Zap with any trigger, add a DataMCP step, and connect it using your Integration key. During the private preview, use the invitation link provided by DataMCP. After Zapier approves the public listing, you will be able to find DataMCP directly in Zapier's app search.
- 4
Choose an operation and test
For a first check, choose Find Database Rows, select your source, and enter SELECT 1 AS connected. Test the step and inspect the result. For a real table, use a bounded query such as SELECT id, label FROM public.orders ORDER BY id LIMIT 10. Then publish your Zap. Create, Update, and Delete Database Row are optional one-row actions that require matching key and database permissions.
Read or write?
Start with a read-only key. A write key can be restricted to one or more selected tables and specific Create, Update, or Delete operations. If you also grant Read Query, it can read the selected source beyond the write-table scope; use a separate key when that matters.
If a step fails
Check that the key is active, the source is selected for it, your plan is active, and the database role has the needed grants. For a Local Agent source, the agent must be online. Do not blindly retry a timed-out write: inspect the row first.
Need access to the private preview? Contact hello@datamcp.app.