Spiral gives your agent every tool with one account. Browse the tools →

Gemini CLI · Finance

How to Use FDIC branch deposits in Gemini CLI

Returns annual branch deposit balances from the FDIC's Summary of Deposits survey, with history since 1994. Use it to calculate local deposit market share or compare a bank's geographic deposit footprint at June 30.

Prompts to try with FDIC branch deposits in Gemini CLI

Copy an example into Gemini CLI, or ask in your own words.

Use FDIC branch deposits to fetch Austin, Texas, office deposits for 2024 and 2025, then add a table of each bank's calculated share of the returned market totals.

FDIC branch depositsGemini CLI
Try asking
  • Use FDIC branch deposits to look this up and give me the result as a table. Save the result in ./assets.

  • Pull the latest numbers from FDIC branch deposits and tell me what changed since last week.

  • Check FDIC branch deposits and summarize what you find in three bullet points.

  • Pull the newest data from FDIC branch deposits and give me the result as a table.

How to set up FDIC branch deposits in Gemini CLI

Pick the way that suits you. Each takes about two minutes.

Use Spiral's MCP server

  1. Add the server

    Or add it to ~/.gemini/settings.json yourself:

    gemini mcp add --scope user --transport http spiral https://api.spiral.ai/mcp
  2. Sign in

    Start gemini and run:

    /mcp auth spiral
  3. Check it

    In Gemini CLI, run /mcp. From your shell:

    gemini mcp list

Use the Spiral skill

  1. Send Gemini CLI this message

    Your agent reads Spiral's skill and sets itself up.

    set up https://spiral.ai/SKILL.md
  2. Sign in or paste a key

    Approve Spiral in the browser, or give the agent a key from the console.

Use the Spiral CLI

  1. Install and sign in

    Installs the Spiral CLI, signs you in and adds its skill to your coding agents.

    npx -y spiral-cli@latest init

Call the Spiral API

  1. Create an API key

    In the console, under API keys.

  2. Run FDIC branch deposits

    One request; the result comes back by polling or a webhook.

    curl https://api.spiral.ai/v1/runs \
      -H "Authorization: Bearer $SPIRAL_API_KEY" \
      -H "Content-Type: application/json" \
      -H "Idempotency-Key: $(uuidgen)" \
      -d '{
        "provider": "alexandria",
        "model": "banks-data-fdic-gov/bank-data/deposits",
        "input": {
          "cert": 1
        }
      }'

Then paste one of the prompts above: Gemini CLI finds FDIC branch deposits on Spiral, shows the price and runs it.

FDIC branch deposits providers and prices

Spiral runs FDIC branch deposits through Alexandria. Open a card for today's price, with every fee included.

AlexandriaFinance
FDIC BankFind Suite · Deposits
banks-data-fdic-gov/bank-data/deposits

Settings you can ask for

Ask Gemini CLI for any of these in your prompt.

SettingAllowed valuesDefaultDescription
Cert1 to 9999999

FDIC certificate number, the institution id shared by every BankFind dataset (3511 = Wells Fargo Bank, N.A.; 628 = JPMorgan Chase Bank, N.A.). Find it with institutions. A number no institution has ever held is not_found.

Year1934 to 2100

One survey year (deposits as of June 30), 1994 onward. Not combinable with from_year / to_year.

To year1934 to 2100

Latest survey year to include.

From year1934 to 2100

Earliest survey year to include.

Page size1 to 100025

Records per page.

Sort orderasc or desc

Direction for every sort column. Defaults to the direction of the default sort.

Every API field of FDIC BankFind Suite · Deposits is on its tool page: open its card above.

What can you do with FDIC branch deposits in Gemini CLI?

Build a bank research dashboard with FDIC institution profiles, branch maps, financial trends, and historical context. Keep annual deposit surveys, quarterly financial reports, structural events, and annual industry totals on their own timelines.

Research a Texas banking market

Identify banks and offices serving Austin, calculate annual deposit shares, and compare the banks' financial scale. Add statewide annual totals to put the local market in context.

Explain a bank's expansion

Combine institution identity, structural events, office locations, annual branch deposits, and quarterly financial reports. Show whether a larger footprint coincides with recorded mergers or financial growth.

Produce a state banking yearbook

Create a California banking reference with institution profiles, office coverage, deposit shares, financial comparisons, structural events, failure records, and annual industry totals. Label each table with its reporting period.

Study a banking crisis

Compare Florida failure and assistance records from 2008 through 2012 with bank financial reports, structural events, and annual statewide totals. Use branch deposit surveys to examine the geographic distribution of deposits during those years.

Compare local banking competitors

List banks serving Charlotte, compare their office networks and annual branch deposits, and place institution financial results beside North Carolina's annual banking totals.

Maintain a public banking dashboard

Display bank profiles, office maps, deposit concentration, financial trends, structural changes, failure records, and annual totals. Refresh each section according to its source reporting cycle.

Check a banking news article

Verify institution names, office locations, deposit figures, financial periods, structural event dates, failure estimates, and industry totals against FDIC records. Keep annual deposit snapshots separate from quarterly financial comparisons.

Questions about FDIC branch deposits in Gemini CLI

Can Gemini CLI use FDIC branch deposits?

Yes. Add Spiral to Gemini CLI as an MCP server, and Gemini CLI can find and run FDIC branch deposits like any built-in tool.

How much does FDIC branch deposits cost in Gemini CLI?

$0.00873 per call. You pay from your Spiral balance as you go, with no subscription, and a failed run is not charged. Your Gemini CLI plan is separate.

Do I need an Alexandria account to use FDIC branch deposits in Gemini CLI?

No. Spiral runs FDIC branch deposits on its own Alexandria account. You sign in to Spiral once and never paste a key.

How long does it take to set up FDIC branch deposits in Gemini CLI?

About two minutes: add the server, then sign in, then check it.

Does Gemini CLI wait while FDIC branch deposits runs?

FDIC branch deposits runs in the background. Gemini CLI starts the run, checks on it and gives you the json when it's ready.

How far back do FDIC records go?

Institution records and failure records extend to 1934. Quarterly financial reporting starts in 1992, and annual branch deposit reports start in 1994.

Is BankFind data live?

FDIC demographic data updates weekly, and financial data updates quarterly. Branch deposits represent June 30 each year, while annual banking summaries use December 31 observations.

What does a branch deposit balance measure?

It is the branch's reported deposit balance at June 30, rather than a current balance. The annual survey includes insured U.S. branches of foreign banks.

Can historical deposit figures change?

Yes. FDIC accepts amendments to Summary of Deposits surveys, including corrected deposit amounts, addresses, county codes, and ZIP codes.

Does every failure record describe a bank closing?

The dataset includes both failures and assistance transactions from 1934 onward. Its financial measures include assets and deposits last reported before failure, and its resolution costs are estimates.

Get started

Start using FDIC branch deposits in Gemini CLI

One Spiral account for every tool your agent needs. No subscription; you pay per run.

Paste this into Gemini CLI:

Set up Gemini CLI

set up https://spiral.ai/SKILL.md
Are you an AI agent? See setup options