Ucc Liens MCP server

@pipeworx/ucc-liens

Business-debtor UCC (Uniform Commercial Code) financing-statement filings — secured loans against a company's assets — for Colorado, Connecticut and Oregon, plus recent-filing lender-activity signals. Each state's own public Secretary of State open-data portal is the source; Vermont is documented as unreachable (see Data sources). Individual debtors are excluded at the query, not filtered afterward, and every response carries an FCRA notice.

Part of Pipeworx — an MCP gateway connecting AI agents to 1745+ live data sources. This is an independent, unofficial integration — not affiliated with, endorsed by, or published by the upstream provider.

Tools

name in CO, CT or OR. Returns file number, filing type/status, filing and lapse dates, debtor name/address, secured party name/address, and a source URL per filing. state: "VT" always throws (see Data sources).

• uccsearch(debtorname, state, limit?) — search filings by business debtor

since a date, for lender-activity signals (who is lending to whom, and when). Same state coverage; optional substring filter on secured-party name.

• uccnewfilings(state, since, secured_party?, limit?) — recent filings

Auth

Keyless. All three live sources are public, unauthenticated open-data APIs.

Data sources

the State, "Uniform Commercial Code (UCC) Lien Filings." One row per lien transaction (original filing, amendment, continuation, release). Business debtors carry debtornmbus; individual debtors carry debtornmlast/ debtornmfirst instead and never debtornmbus — the pack's $where requires debtornmbus IS NOT NULL, so an individual-debtor row is never fetched. No collateral description field is published in this dataset.

• — Connecticut Secretary of

(debtors), (secured parties) — Colorado Secretary of State UCC, as three separate Socrata datasets joined in-memory by fileid (there is no server-side join). Debtors carry organizationname when a business, firstname/lastname when an individual — the pack queries the debtors dataset with organizationname IS NOT NULL first and only ever fetches filings/secured parties for the fileids that search returned. A fourth dataset, 4am6-w6u4 (collateral), exists but is not queried in v1 to keep response size bounded — the schema is simple to add if a caller asks for it.

• (filings),

State, "UCC List of Filings Entered Last Month." This is a rolling ~30-day window, not the full historical index — the dataset name is literal; it is replaced monthly, not accumulated. partytype is DB (debtor) or SP (secured party); entitytype is ORG or IND. The pack requires partytype = 'DB' AND entitytype = 'ORG' for search/new-filings, then makes a second query for the matching SP row(s) by originalfilenumber to attach the secured party. A debtor with no filing in roughly the last month will not appear even if its lien is still active — this is a genuine coverage limit, documented in every Oregon filing's coveragenote field, not a bug. Oregon's full-history search (secure.sos.state.or.us/ucc/searchHome.action → POST /ucc/search.action) is not used in v1, but it is reachable** — edge-probed live from a throwaway Cloudflare Worker on the prod account (2026-10-08): GET the search form for a CSRFToken + session cookie, then POST a debtor search, and it returns a clean "Welcome Public User" results page (verified with debtor NIKE, 2 live liens), no bot challenge, 3/3 runs. It is skipped anyway because its results LIST has no secured-party column — getting one means an extra per-filing detail-page

• — Oregon Secretary of

Shortened. The full README is on GitHub.