Database integration
Read-only Postgres access to the full ATS feed catalog after checkout — connect, query, and explore with SQL.
What's included
| Detail | Value |
|---|---|
| Access | Read-only SQL |
| Connections | 5 per login |
| Query timeout | 30 seconds |
| Catalog refresh | Once a day |
| Data transfer (fair use) | Up to 100 GB / month |
| Server load (fair use) | No sustained heavy load |
How it works
After checkout you receive your own database login by email, usually within a minute. It gives read-only SQL access to a shared Postgres copy of the full ATS Feeds catalog, refreshed once a day.
If the email doesn't arrive, check spam or use the contact form.
Connect
Use the connection URI from the email with any Postgres client:
psql "postgresql://USER:PASSWORD@db.atsfeeds.com:5432/atsfeeds?sslmode=require&channel_binding=require"If your driver rejects channel_binding, remove that parameter and keep sslmode=require.
The data
You query two views: atsfeeds.feeds (the catalog) and atsfeeds.catalog_status (when that catalog was last refreshed).
atsfeeds.feeds — one row per feed. Columns:
| Column | Type | Meaning |
|---|---|---|
id | uuid | Feed id, same as in the API and CSV |
ats_platform | text | e.g. greenhouse, lever |
account_slug | text | The company's account on that platform |
feed_url | text | URL of the job feed |
company_name | text | May be empty |
job_count | integer | Open jobs at the last check |
available_since | timestamptz | When the feed last became active |
status | text | active, unavailable, or retired |
retired_at | timestamptz | When the feed was retired; empty otherwise |
atsfeeds.catalog_status — a single-row view with when the catalog was last loaded, plus feed totals. Check it with:
SELECT * FROM atsfeeds.catalog_status;Example queries on atsfeeds.feeds:
-- Feeds per ATS platform
SELECT ats_platform, count(*) FROM atsfeeds.feeds
WHERE status = 'active' GROUP BY 1 ORDER BY 2 DESC;-- Active feeds with the most open jobs
SELECT company_name, ats_platform, feed_url, job_count FROM atsfeeds.feeds
WHERE status = 'active' ORDER BY job_count DESC NULLS LAST LIMIT 20;Passwords
Your password works immediately. Change it with \password in psql (or ALTER ROLE CURRENT_USER WITH PASSWORD 'new-password').
Lost it? Contact us and we'll reset it.
Help
Questions? Contact us. Use of the data is subject to the terms.
Database access
Flexible SQL + retired feeds — $50/mo