Database Replica

:::tip Enterprise Feature Access to a fully isolated, daily-updated database replica is available for enterprise clients. This is not included with standard API access.

The replica enables you to fully ingest and customize data for your own use cases. It is powered by logical replication through NeonDB Postgres.

Contact sales@midpage.ai to learn more about enterprise access. :::

Connect to the Midpage read replica using PostgreSQL.

Connection String

postgresql://user:password@host:port/database

Connecting with psql

psql "postgresql://user:password@host:port/database"

Connecting with Python

import psycopg2

conn = psycopg2.connect(
    host="host",
    port="port",
    database="database",
    user="user",
    password="password"
)

cursor = conn.cursor()
cursor.execute("SELECT * FROM opinions.courts LIMIT 10")
rows = cursor.fetchall()

Connecting with Node.js

import { Pool } from 'pg'

const pool = new Pool({
  connectionString: process.env.DATABASE_URL
})

const result = await pool.query('SELECT * FROM opinions.courts LIMIT 10')
console.log(result.rows)

Schema Access

The database contains two schemas:

opinions — Court opinions and caselaw
laws — Statutes and regulations

-- List all tables in opinions schema
SELECT table_name 
FROM information_schema.tables 
WHERE table_schema = 'opinions';

-- List all tables in laws schema
SELECT table_name 
FROM information_schema.tables 
WHERE table_schema = 'laws';

See the Schema Reference for complete table documentation.

Change Tracking

All tables include an updated_at column with automatic triggers. This timestamp is updated whenever a row is modified, helping you track changes made on our end.

-- Find recently updated opinions
SELECT id, case_name, updated_at
FROM opinions.docket_entries
WHERE updated_at > NOW() - INTERVAL '7 days'
ORDER BY updated_at DESC;

This is useful for incremental syncs—you can query for rows where updated_at is greater than your last sync timestamp.