{"id":"e7b11c03-16b2-4127-9682-64279cc8086c","shortId":"nnhJ78","kind":"skill","title":"junta-leiloeiros","tagline":"Coleta e consulta dados de leiloeiros oficiais de todas as 27 Juntas Comerciais do Brasil. Scraper multi-UF, banco SQLite, API FastAPI e exportacao CSV/JSON.","description":"# Skill: Leiloeiros das Juntas Comerciais do Brasil\n\n## Overview\n\nColeta e consulta dados de leiloeiros oficiais de todas as 27 Juntas Comerciais do Brasil. Scraper multi-UF, banco SQLite, API FastAPI e exportacao CSV/JSON.\n\n## When to Use This Skill\n\n- When the user mentions \"leiloeiro junta\" or related topics\n- When the user mentions \"junta comercial leiloeiro\" or related topics\n- When the user mentions \"scraper junta\" or related topics\n- When the user mentions \"jucesp leiloeiro\" or related topics\n- When the user mentions \"jucerja\" or related topics\n- When the user mentions \"jucemg leiloeiro\" or related topics\n\n## Do Not Use This Skill When\n\n- The task is unrelated to junta leiloeiros\n- A simpler, more specific tool can handle the request\n- The user needs general-purpose assistance without domain expertise\n\n## How It Works\n\nColeta dados públicos de leiloeiros oficiais de todas as 27 Juntas Comerciais estaduais,\npersiste em banco SQLite local e oferece API REST e exportação em múltiplos formatos.\n\n## Localização\n\n```\nC:\\Users\\renat\\skills\\junta-leiloeiros\\\n├── scripts/\n│   ├── scraper/\n│   │   ├── base_scraper.py      ← classe abstrata\n│   │   ├── states.py            ← registro dos 27 scrapers\n│   │   ├── jucesp.py / jucerja.py / jucemg.py / jucec.py / jucis_df.py\n│   │   └── generic_scraper.py   ← usado pelos 22 estados restantes\n│   ├── db.py                    ← banco SQLite\n│   ├── run_all.py               ← orquestrador de scraping\n│   ├── serve_api.py             ← API FastAPI\n│   ├── export.py                ← exportação\n│   └── requirements.txt\n├── references/\n│   ├── juntas_urls.md           ← URLs e status de todas as 27 juntas\n│   ├── schema.md                ← schema do banco\n│   └── legal.md                 ← base legal\n└── data/\n    ├── leiloeiros.db            ← banco SQLite (criado no primeiro run)\n    ├── scraping_log.json        ← log de cada coleta\n    └── exports/                 ← arquivos exportados\n```\n\n## Instalação (Uma Vez)\n\n```bash\npip install -r C:\\Users\\renat\\skills\\junta-leiloeiros\\scripts\\requirements.txt\n\n## Para Sites Com Javascript:\n\nplaywright install chromium\n```\n\n## Coletar Dados\n\n```bash\n\n## Todos Os 27 Estados\n\npython C:\\Users\\renat\\skills\\junta-leiloeiros\\scripts\\run_all.py\n\n## Estados Específicos\n\npython C:\\Users\\renat\\skills\\junta-leiloeiros\\scripts\\run_all.py --estado SP RJ MG\n\n## Ver O Que Seria Coletado Sem Executar\n\npython C:\\Users\\renat\\skills\\junta-leiloeiros\\scripts\\run_all.py --dry-run\n\n## Controlar Paralelismo (Default: 5)\n\npython C:\\Users\\renat\\skills\\junta-leiloeiros\\scripts\\run_all.py --concurrency 3\n```\n\n## Estatísticas Por Estado\n\npython C:\\Users\\renat\\skills\\junta-leiloeiros\\scripts\\db.py\n\n## Sql Direto\n\nsqlite3 C:\\Users\\renat\\skills\\junta-leiloeiros\\data\\leiloeiros.db \\\n  \"SELECT estado, COUNT(*) FROM leiloeiros GROUP BY estado\"\n```\n\n## Servir Api Rest\n\n```bash\npython C:\\Users\\renat\\skills\\junta-leiloeiros\\scripts\\serve_api.py\n\n## Docs Interativos: Http://Localhost:8000/Docs\n\n```\n\n**Endpoints:**\n- `GET /leiloeiros?estado=SP&situacao=ATIVO&nome=silva&limit=100`\n- `GET /leiloeiros/{estado}` — ex: `/leiloeiros/SP`\n- `GET /busca?q=texto`\n- `GET /stats`\n- `GET /export/json`\n- `GET /export/csv`\n\n## Exportar Dados\n\n```bash\npython C:\\Users\\renat\\skills\\junta-leiloeiros\\scripts\\export.py --format csv\npython C:\\Users\\renat\\skills\\junta-leiloeiros\\scripts\\export.py --format json\npython C:\\Users\\renat\\skills\\junta-leiloeiros\\scripts\\export.py --format all\npython C:\\Users\\renat\\skills\\junta-leiloeiros\\scripts\\export.py --format csv --estado SP\n```\n\n## Usar Em Código Python\n\n```python\nimport sys\nsys.path.insert(0, r\"C:\\Users\\renat\\skills\\junta-leiloeiros\\scripts\")\nfrom db import Database\n\ndb = Database()\ndb.init()\n\n## Todos Os Leiloeiros Ativos De Sp\n\nleiloeiros = db.get_all(estado=\"SP\", situacao=\"ATIVO\")\n\n## Busca Por Nome\n\nresultados = db.search(\"silva\")\n\n## Estatísticas\n\nstats = db.get_stats()\n```\n\n## Adicionar Scraper Customizado\n\nSe um estado precisar de lógica específica (ex: site usa JavaScript):\n\n```python\n\n## Scripts/Scraper/Meu_Estado.Py\n\nfrom .base_scraper import AbstractJuntaScraper, Leiloeiro\nfrom typing import List\n\nclass MeuEstadoScraper(AbstractJuntaScraper):\n    estado = \"XX\"\n    junta = \"JUCEX\"\n    url = \"https://www.jucex.xx.gov.br/leiloeiros\"\n\n    async def parse_leiloeiros(self) -> List[Leiloeiro]:\n        soup = await self.fetch_page()\n        if not soup:\n            return []\n        # lógica específica aqui\n        return [self.make_leiloeiro(nome=\"...\", matricula=\"...\")]\n```\n\nRegistrar em `scripts/scraper/states.py`:\n```python\nfrom .meu_estado import MeuEstadoScraper\nSCRAPERS[\"XX\"] = MeuEstadoScraper\n```\n\n## Referências\n\n- URLs de todas as juntas: `references/juntas_urls.md`\n- Schema do banco: `references/schema.md`\n- Base legal da coleta: `references/legal.md`\n- Log de coleta: `data/scraping_log.json`\n\n## Best Practices\n\n- Provide clear, specific context about your project and requirements\n- Review all suggestions before applying them to production code\n- Combine with other complementary skills for comprehensive analysis\n\n## Common Pitfalls\n\n- Using this skill for tasks outside its domain expertise\n- Applying recommendations without understanding your specific context\n- Not providing enough project context for accurate analysis\n\n## Related Skills\n\n- `leiloeiro-avaliacao` - Complementary skill for enhanced analysis\n- `leiloeiro-edital` - Complementary skill for enhanced analysis\n- `leiloeiro-ia` - Complementary skill for enhanced analysis\n- `leiloeiro-juridico` - Complementary skill for enhanced analysis\n- `leiloeiro-mercado` - Complementary skill for enhanced analysis\n\n## Limitations\n- Use this skill only when the task clearly matches the scope described above.\n- Do not treat the output as a substitute for environment-specific validation, testing, or expert review.\n- Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.","tags":["junta","leiloeiros","antigravity","awesome","skills","sickn33","agent-skills","agentic-skills","ai-agent-skills","ai-agents","ai-coding","ai-workflows"],"capabilities":["skill","source-sickn33","skill-junta-leiloeiros","topic-agent-skills","topic-agentic-skills","topic-ai-agent-skills","topic-ai-agents","topic-ai-coding","topic-ai-workflows","topic-antigravity","topic-antigravity-skills","topic-claude-code","topic-claude-code-skills","topic-codex-cli","topic-codex-skills"],"categories":["antigravity-awesome-skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/sickn33/antigravity-awesome-skills/junta-leiloeiros","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add sickn33/antigravity-awesome-skills","source_repo":"https://github.com/sickn33/antigravity-awesome-skills","install_from":"skills.sh"}},"qualityScore":"0.700","qualityRationale":"deterministic score 0.70 from registry signals: · indexed on github topic:agent-skills · 34726 github stars · SKILL.md body (5,964 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-04-23T12:51:07.531Z","embedding":null,"createdAt":"2026-04-18T21:39:29.623Z","updatedAt":"2026-04-23T12:51:07.531Z","lastSeenAt":"2026-04-23T12:51:07.531Z","tsv":"'/busca':420 '/export/csv':428 '/export/json':426 '/leiloeiros':405,415,566 '/leiloeiros/sp':418 '/stats':424 '0':490 '100':413 '22':211 '27':14,48,167,201,235,288 '3':351 '5':339 '8000/docs':402 'abstractjuntascrap':550,558 'abstrata':197 'accur':674 'adicionar':530 'analysi':649,675,685,693,701,709,717 'api':25,59,178,222,386 'appli':637,661 'aqui':584 'arquivo':258 'ask':751 'assist':151 'async':567 'ativo':409,510,519 'avaliacao':680 'await':575 'banco':23,57,173,215,240,246,611 'base':242,547,613 'base_scraper.py':195 'bash':263,285,388,431 'best':622 'boundari':759 'brasil':18,36,52 'busca':520 'c':186,267,291,303,324,341,356,368,390,433,445,457,469,492 'cada':255 'chromium':282 'clarif':753 'class':196,556 'clear':625,726 'code':641 'coleta':4,38,158,256,616,620 'coletado':320 'coletar':283 'com':278 'combin':642 'comerci':83 'comerciai':16,34,50,169 'common':650 'complementari':645,681,689,697,705,713 'comprehens':648 'concurr':350 'consulta':6,40 'context':627,667,672 'controlar':336 'count':379 'criado':248 'criteria':762 'csv':443,479 'csv/json':29,63 'customizado':532 'código':484 'da':615 'dado':7,41,159,284,430 'das':32 'data':244,375 'data/scraping_log.json':621 'databas':503,505 'db':501,504 'db.get':514,528 'db.init':506 'db.py':214,364 'db.search':524 'de':8,11,42,45,161,164,219,232,254,511,537,604,619 'def':568 'default':338 'describ':730 'direto':366 'doc':399 'domain':153,659 'dos':200 'dri':334 'dry-run':333 'e':5,27,39,61,176,180,230 'edit':688 'em':172,182,483,591 'endpoint':403 'enhanc':684,692,700,708,716 'enough':670 'environ':742 'environment-specif':741 'específica':539,583 'específico':301 'estado':212,289,300,312,354,378,384,406,416,480,516,535,559,596 'estaduai':170 'estatística':352,526 'ex':417,540 'executar':322 'expert':747 'expertis':154,660 'export':257 'export.py':224,441,453,465,477 'exportacao':28,62 'exportado':259 'exportar':429 'exportação':181,225 'fastapi':26,60,223 'format':442,454,466,478 'formato':184 'general':149 'general-purpos':148 'generic_scraper.py':208 'get':404,414,419,423,425,427 'group':382 'handl':142 'ia':696 'import':487,502,549,554,597 'input':756 'instal':265,281 'instalação':260 'interativo':400 'javascript':279,543 'json':455 'jucec.py':206 'jucemg':118 'jucemg.py':205 'jucerja':110 'jucerja.py':204 'jucesp':101 'jucesp.py':203 'jucex':562 'jucis_df.py':207 'junta':2,15,33,49,74,82,93,134,168,191,236,272,296,308,329,346,361,373,395,438,450,462,474,497,561,607 'junta-leiloeiro':1,190,271,295,307,328,345,360,372,394,437,449,461,473,496 'juntas_urls.md':228 'juridico':704 'legal':243,614 'legal.md':241 'leiloeiro':3,9,31,43,73,84,102,119,135,162,192,273,297,309,330,347,362,374,381,396,439,451,463,475,498,509,513,551,570,573,587,679,687,695,703,711 'leiloeiro-avaliacao':678 'leiloeiro-edit':686 'leiloeiro-ia':694 'leiloeiro-juridico':702 'leiloeiro-mercado':710 'leiloeiros.db':245,376 'limit':412,718 'list':555,572 'local':175 'localhost':401 'localização':185 'log':253,618 'lógica':538,582 'match':727 'matricula':589 'mention':72,81,91,100,109,117 'mercado':712 'meu':595 'meuestadoscrap':557,598,601 'mg':315 'miss':764 'multi':21,55 'multi-uf':20,54 'múltiplo':183 'need':147 'nome':410,522,588 'o':317 'oferec':177 'oficiai':10,44,163 'orquestrador':218 'os':287,508 'output':736 'outsid':657 'overview':37 'page':577 'para':276 'paralelismo':337 'pars':569 'pelo':210 'permiss':757 'persist':171 'pip':264 'pitfal':651 'playwright':280 'por':353,521 'practic':623 'precisar':536 'primeiro':250 'product':640 'project':630,671 'provid':624,669 'purpos':150 'python':290,302,323,340,355,389,432,444,456,468,485,486,544,593 'público':160 'q':421 'que':318 'r':266,491 'recommend':662 'refer':227 'references/juntas_urls.md':608 'references/legal.md':617 'references/schema.md':612 'referência':602 'registrar':590 'registro':199 'relat':76,86,95,104,112,121,676 'renat':188,269,293,305,326,343,358,370,392,435,447,459,471,494 'request':144 'requir':632,755 'requirements.txt':226,275 'rest':179,387 'restant':213 'resultado':523 'return':581,585 'review':633,748 'rj':314 'run':251,335 'run_all.py':217,299,311,332,349 'safeti':758 'schema':238,609 'schema.md':237 'scope':729 'scrape':220 'scraper':19,53,92,194,202,531,548,599 'scraping_log.json':252 'script':193,274,298,310,331,348,363,397,440,452,464,476,499 'scripts/scraper/meu_estado.py':545 'scripts/scraper/states.py':592 'se':533 'select':377 'self':571 'self.fetch':576 'self.make':586 'sem':321 'seria':319 'serve_api.py':221,398 'servir':385 'silva':411,525 'simpler':137 'site':277,541 'situacao':408,518 'skill':30,68,127,189,270,294,306,327,344,359,371,393,436,448,460,472,495,646,654,677,682,690,698,706,714,721 'skill-junta-leiloeiros' 'soup':574,580 'source-sickn33' 'sp':313,407,481,512,517 'specif':139,626,666,743 'sql':365 'sqlite':24,58,174,216,247 'sqlite3':367 'stat':527,529 'states.py':198 'status':231 'stop':749 'substitut':739 'success':761 'suggest':635 'sys':488 'sys.path.insert':489 'task':130,656,725 'test':745 'texto':422 'toda':12,46,165,233,605 'todo':286,507 'tool':140 'topic':77,87,96,105,113,122 'topic-agent-skills' 'topic-agentic-skills' 'topic-ai-agent-skills' 'topic-ai-agents' 'topic-ai-coding' 'topic-ai-workflows' 'topic-antigravity' 'topic-antigravity-skills' 'topic-claude-code' 'topic-claude-code-skills' 'topic-codex-cli' 'topic-codex-skills' 'treat':734 'type':553 'uf':22,56 'um':534 'uma':261 'understand':664 'unrel':132 'url':229,563,603 'usa':542 'usado':209 'usar':482 'use':66,125,652,719 'user':71,80,90,99,108,116,146,187,268,292,304,325,342,357,369,391,434,446,458,470,493 'valid':744 'ver':316 'vez':262 'without':152,663 'work':157 'www.jucex.xx.gov.br':565 'www.jucex.xx.gov.br/leiloeiros':564 'xx':560,600","prices":[{"id":"0d3ecca3-e417-4bfc-8738-e8643d98482c","listingId":"e7b11c03-16b2-4127-9682-64279cc8086c","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"sickn33","category":"antigravity-awesome-skills","install_from":"skills.sh"},"createdAt":"2026-04-18T21:39:29.623Z"}],"sources":[{"listingId":"e7b11c03-16b2-4127-9682-64279cc8086c","source":"github","sourceId":"sickn33/antigravity-awesome-skills/junta-leiloeiros","sourceUrl":"https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/junta-leiloeiros","isPrimary":false,"firstSeenAt":"2026-04-18T21:39:29.623Z","lastSeenAt":"2026-04-23T12:51:07.531Z"}],"details":{"listingId":"e7b11c03-16b2-4127-9682-64279cc8086c","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"sickn33","slug":"junta-leiloeiros","github":{"repo":"sickn33/antigravity-awesome-skills","stars":34726,"topics":["agent-skills","agentic-skills","ai-agent-skills","ai-agents","ai-coding","ai-workflows","antigravity","antigravity-skills","claude-code","claude-code-skills","codex-cli","codex-skills","cursor","cursor-skills","developer-tools","gemini-cli","gemini-skills","kiro","mcp","skill-library"],"license":"mit","html_url":"https://github.com/sickn33/antigravity-awesome-skills","pushed_at":"2026-04-23T06:41:03Z","description":"Installable GitHub library of 1,400+ agentic skills for Claude Code, Cursor, Codex CLI, Gemini CLI, Antigravity, and more. Includes installer CLI, bundles, workflows, and official/community skill collections.","skill_md_sha":"3b64d5fa274c944999b1228ec48bdf4caba04d1a","skill_md_path":"skills/junta-leiloeiros/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/junta-leiloeiros"},"layout":"multi","source":"github","category":"antigravity-awesome-skills","frontmatter":{"name":"junta-leiloeiros","description":"Coleta e consulta dados de leiloeiros oficiais de todas as 27 Juntas Comerciais do Brasil. Scraper multi-UF, banco SQLite, API FastAPI e exportacao CSV/JSON."},"skills_sh_url":"https://skills.sh/sickn33/antigravity-awesome-skills/junta-leiloeiros"},"updatedAt":"2026-04-23T12:51:07.531Z"}}