DQ DocQuery
Start free

Airtable + PDFs

One API over your Airtable base and the PDFs that go with it.

Your customers or contracts live in Airtable. The invoices, statements, and signed agreements live in PDFs. DocQuery imports the Airtable table, extracts the PDFs into tables, and lets you link them with a foreign key, so one REST, GraphQL, or MCP call returns a record together with its documents.

Start free How it works

How it works

1

Connect Airtable

Sign in with Airtable (OAuth), then pick a base, a table, and an optional view. DocQuery imports the records as a table.
2

Keep it live

Turn on live sync and DocQuery registers an Airtable webhook, pulling remote changes as they happen. Edits you make in DocQuery are written back to Airtable.
3

Add the PDFs

Upload the invoices or contracts. AI extraction turns each file into rows with typed columns, such as invoice number, customer id, amount, and due date.
4

Link and query

Define a relation like invoices.customer_id → customers.id. The API can then embed related rows with include=, and MCP clients can follow the link.

What a call looks like

Rows from the PDF-extracted invoices table, each with its Airtable customer embedded. Filter on any column with ?column=value. 

curl -H "Authorization: Bearer YOUR_API_KEY" \
  "https://docquery.io/api/v1/tables/invoices/rows?status=unpaid&include=customer_id"

Try a real call now, no signup. This uses the public read-only demo key (example customers and invoices): 

curl -H "Authorization: Bearer dq_demo_readonly" \
  "https://docquery.io/api/v1/tables/example_invoices/rows?status=due&include=customer_id"

The same data is available over GraphQL and over a hosted MCP server for Claude and Cursor.

When this is the right tool

  • You need the Airtable record and the numbers inside its attached documents in one response.
  • You want an AI agent to answer questions across the base and the PDFs.
  • If you only need an API over a plain Airtable table, Airtable's own API already does that. DocQuery is for when the PDFs matter too.
Get started free

Free plan: 5 documents and 10,000 rows, no card. Airtable is available on every plan.