{"id":"7b479467-adb6-4abf-94fb-536133df318c","shortId":"xZfeYR","kind":"skill","title":"Migrate MySQL, SQLite, or CSV data into PostgreSQL with repeatable load files before cutover with pgloader","tagline":"Move data into PostgreSQL with declarative load files, built-in type conversion, and repeatable migration runs before one-off import scripts become cutover risk.","description":"# Migrate MySQL, SQLite, or CSV data into PostgreSQL with repeatable load files before cutover with pgloader\n\nMove data into PostgreSQL with declarative load files, built-in type conversion, and repeatable migration runs before one-off import scripts become cutover risk.\n\n## Prerequisites\n\npgloader and access to source systems plus a PostgreSQL target\n\n## Installation\n\nUse the upstream install or setup path that matches your environment:\n- $ docker pull ghcr.io/dimitri/pgloader:latest\n- $ docker run --rm -it ghcr.io/dimitri/pgloader:latest pgloader --version\n\nRequirements and caveats from upstream:\n- If you're using docker, you can use the latest version built by the CI at\n\nBasic usage or getting-started notes:\n- pgloader also implements data reformatting, a typical example of that\n- --help -h boolean Show usage and exit.\n- --dry-run boolean Only check database connections, don't load anything.\n\n- Source: https://github.com/dimitri/pgloader\n- Extracted from upstream docs: https://raw.githubusercontent.com/dimitri/pgloader/HEAD/README.md\n\n## Documentation\n\n- https://pgloader.readthedocs.io/en/latest/\n\n## Source\n\n- [Agent Skill Exchange](https://agentskillexchange.com/skills/migrate-mysql-sqlite-or-csv-data-into-postgresql-with-repeatable-load-files-before-cutover-with-pgloader/)","tags":["migrate","mysql","sqlite","csv","data","into","postgresql","with","repeatable","load","files","before"],"capabilities":["skill","source-agentskillexchange","skill-migrate-mysql-sqlite-or-csv-data-into-postgresql-with-repeatable-load-files-before-cutover-with-pgloader","topic-agent-skills","topic-ai-agents","topic-ai-tools","topic-awesome-list","topic-claude-code","topic-codex","topic-cursor","topic-llm","topic-mcp","topic-npx-skills","topic-openclaw","topic-skills-catalog"],"categories":["skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/agentskillexchange/skills/migrate-mysql-sqlite-or-csv-data-into-postgresql-with-repeatable-load-files-before-cutover-with-pgloader","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add agentskillexchange/skills","source_repo":"https://github.com/agentskillexchange/skills","install_from":"skills.sh"}},"qualityScore":"0.454","qualityRationale":"deterministic score 0.45 from registry signals: · indexed on github topic:agent-skills · 8 github stars · SKILL.md body (1,298 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-05-18T19:11:19.587Z","embedding":null,"createdAt":"2026-05-18T13:17:46.053Z","updatedAt":"2026-05-18T19:11:19.587Z","lastSeenAt":"2026-05-18T19:11:19.587Z","tsv":"'/dimitri/pgloader':182 '/dimitri/pgloader/head/readme.md':189 '/dimitri/pgloader:latest':112,119 '/en/latest/':193 '/skills/migrate-mysql-sqlite-or-csv-data-into-postgresql-with-repeatable-load-files-before-cutover-with-pgloader/)':200 'access':88 'agent':195 'agentskillexchange.com':199 'agentskillexchange.com/skills/migrate-mysql-sqlite-or-csv-data-into-postgresql-with-repeatable-load-files-before-cutover-with-pgloader/)':198 'also':151 'anyth':178 'basic':143 'becom':40,82 'boolean':162,170 'built':26,68,138 'built-in':25,67 'caveat':124 'check':172 'ci':141 'connect':174 'convers':29,71 'csv':5,47 'cutov':14,41,56,83 'data':6,18,48,60,153 'databas':173 'declar':22,64 'doc':186 'docker':108,113,131 'document':190 'dri':168 'dry-run':167 'environ':107 'exampl':157 'exchang':197 'exit':166 'extract':183 'file':12,24,54,66 'get':147 'getting-start':146 'ghcr.io':111,118 'ghcr.io/dimitri/pgloader:latest':110,117 'github.com':181 'github.com/dimitri/pgloader':180 'h':161 'help':160 'implement':152 'import':38,80 'instal':96,100 'latest':136 'load':11,23,53,65,177 'match':105 'migrat':1,32,43,74 'move':17,59 'mysql':2,44 'note':149 'one':36,78 'one-off':35,77 'path':103 'pgloader':16,58,86,120,150 'pgloader.readthedocs.io':192 'pgloader.readthedocs.io/en/latest/':191 'plus':92 'postgresql':8,20,50,62,94 'prerequisit':85 'pull':109 'raw.githubusercontent.com':188 'raw.githubusercontent.com/dimitri/pgloader/head/readme.md':187 're':129 'reformat':154 'repeat':10,31,52,73 'requir':122 'risk':42,84 'rm':115 'run':33,75,114,169 'script':39,81 'setup':102 'show':163 'skill':196 'skill-migrate-mysql-sqlite-or-csv-data-into-postgresql-with-repeatable-load-files-before-cutover-with-pgloader' 'sourc':90,179,194 'source-agentskillexchange' 'sqlite':3,45 'start':148 'system':91 'target':95 'topic-agent-skills' 'topic-ai-agents' 'topic-ai-tools' 'topic-awesome-list' 'topic-claude-code' 'topic-codex' 'topic-cursor' 'topic-llm' 'topic-mcp' 'topic-npx-skills' 'topic-openclaw' 'topic-skills-catalog' 'type':28,70 'typic':156 'upstream':99,126,185 'usag':144,164 'use':97,130,134 'version':121,137","prices":[{"id":"7b0b28cc-33b5-4498-986d-56e9284d14ea","listingId":"7b479467-adb6-4abf-94fb-536133df318c","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"agentskillexchange","category":"skills","install_from":"skills.sh"},"createdAt":"2026-05-18T13:17:46.053Z"}],"sources":[{"listingId":"7b479467-adb6-4abf-94fb-536133df318c","source":"github","sourceId":"agentskillexchange/skills/migrate-mysql-sqlite-or-csv-data-into-postgresql-with-repeatable-load-files-before-cutover-with-pgloader","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/migrate-mysql-sqlite-or-csv-data-into-postgresql-with-repeatable-load-files-before-cutover-with-pgloader","isPrimary":false,"firstSeenAt":"2026-05-18T13:17:46.053Z","lastSeenAt":"2026-05-18T19:11:19.587Z"}],"details":{"listingId":"7b479467-adb6-4abf-94fb-536133df318c","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"migrate-mysql-sqlite-or-csv-data-into-postgresql-with-repeatable-load-files-before-cutover-with-pgloader","github":{"repo":"agentskillexchange/skills","stars":8,"topics":["agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex","cursor","llm","mcp","npx-skills","openclaw","skills-catalog"],"license":"mit","html_url":"https://github.com/agentskillexchange/skills","pushed_at":"2026-05-18T19:02:17Z","description":"The open catalog of AI agent skills — 2,000+ security-scanned skills for Claude Code, Cursor, Codex, and more.","skill_md_sha":"ac8a425755730f9a0092dd314e97a43bdfe3b847","skill_md_path":"skills/migrate-mysql-sqlite-or-csv-data-into-postgresql-with-repeatable-load-files-before-cutover-with-pgloader/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/migrate-mysql-sqlite-or-csv-data-into-postgresql-with-repeatable-load-files-before-cutover-with-pgloader"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"Migrate MySQL, SQLite, or CSV data into PostgreSQL with repeatable load files before cutover with pgloader","description":"Move data into PostgreSQL with declarative load files, built-in type conversion, and repeatable migration runs before one-off import scripts become cutover risk."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/migrate-mysql-sqlite-or-csv-data-into-postgresql-with-repeatable-load-files-before-cutover-with-pgloader"},"updatedAt":"2026-05-18T19:11:19.587Z"}}