Test Json Sql Search Web
Helps with testing, JSON, search as part of working with databases and data persistence workflows.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add test-json-sql-search-web npx -- -y @trustedskills/test-json-sql-search-web
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"test-json-sql-search-web": {
"command": "npx",
"args": [
"-y",
"@trustedskills/test-json-sql-search-web"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill allows AI agents to search web pages, extract JSON data from them, and then execute SQL queries against that data. It combines web scraping capabilities with structured data processing and database interaction. The agent can effectively pull information from online sources and analyze it using SQL logic.
When to use it
- Competitive Pricing Analysis: Scrape product listings from competitor websites, extract pricing information in JSON format, and identify the most competitive offers via SQL queries.
- Real Estate Market Research: Gather property data (listings) from real estate websites, parse the JSON responses, and analyze trends using SQL to determine average prices or available inventory.
- Financial Data Extraction & Analysis: Extract financial data presented in JSON format on web pages related to stock performance or market indicators, then use SQL for calculations and comparisons.
- Lead Generation from Online Directories: Scrape business listings from online directories (e.g., Yelp), extract contact details as JSON, and filter leads using SQL based on specific criteria.
Key capabilities
- Web page scraping
- JSON data extraction
- SQL query execution
- Data integration from web sources and databases
Example prompts
- "Scrape the product listings from example.com/products.json, extract the price and name of each item, and find the cheapest one."
- "Get the latest stock prices for Apple and Microsoft from finance.example.com/stocks.json, then calculate their percentage difference using SQL."
- “Find all restaurants in San Francisco listed on yelp.example.com that have a rating above 4 stars, extract their names and addresses as JSON.”
Tips & gotchas
- The skill's effectiveness depends heavily on the structure of the target web pages and the consistency of the JSON data they contain. Ensure the website’s format is predictable for reliable scraping.
Tags
TrustedSkills Verification
Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.
Security Audits
| Gen Agent Trust Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.