Yelp API ETL — Business Search to PostgreSQL

    1

    Fetch Yelp Fusion business search results with Python and load business details into a PostgreSQL database.

    Free

    Security scanned

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    Yelp API ETL — Business Search to PostgreSQL

    Example session with this skill installed

    Run a Yelp Fusion search for restaurants in Montreal and store the results in PostgreSQL.

    • Read your context and instructions
    • Compiled the yelp api etl

    Configuration and command-line instructions, plus guidance on the resulting yelp.business table.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    A Python ETL example that calls Yelp Fusion Business Search using search term, location, and price filters, parses business details, and stores them in a PostgreSQL yelp.business table with an upsert query. Includes setup guidance for the source modules. The buyer must create config.cfg with their own Yelp API and database credentials. Review SQL parameterization, transaction handling, and current Yelp API terms before production or commercial use.

    config.cfg is not included. Source uses SQL string formatting instead of parameterized queries and lacks robust retry, rate-limit, transaction cleanup, and connection-close handling. Follow Yelp's current API terms.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Free forever

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 2 days ago

    • Free with an Agensi account

    Requires

    Yelp
    Python 3
    Yelp Fusion API key
    PostgreSQL database
    Python

    Permissions

    Allowed Hosts

    api.yelp.com

    File Scopes

    Yelp
    API
    ETL
    project
    documentation

    Buyer supplies their own Yelp API credentials and PostgreSQL database.

    Listed2 days ago

    What's inside

    Frequently Asked Questions

    Fetch Yelp Fusion business search results with Python and load business details into a PostgreSQL database.

    This skill uses the open SKILL.md standard. Use it through an MCP-compatible agent connected to Agensi, and check the compatibility information on this page for confirmed agents and required capabilities.

    Connect your AI agent to Agensi through MCP, then ask it to use Yelp API ETL — Business Search to PostgreSQL on your task. Your agent loads the latest approved version each time. Paid skills require a purchase or active subscription. Skill files are not available for download; your licence does not allow you to save, copy or export any part of a skill.

    New in Data & Databases