laravel-mysql-to-postgres SKILL.md skillA

laravel-mysql-to-postgres from majdghithan/agent-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add majdghithan/agent-skills/laravel-mysql-to-postgres@git:20260729.b363e32

Pins git:20260729.b363e32 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
majdghithan/agent-skills
Path
skills/laravel-mysql-to-postgres/SKILL.md
Versions recorded
1
Latest version
git:20260729.b363e32, committed Jul 29, 2026
Size
5,714 bytes
Repository stars
8
License
MIT

Migrate a Laravel application's database from MySQL/MariaDB to PostgreSQL safely. Use when moving a Laravel app to Postgres, when Eloquent/queries behave differently after switching drivers, or when planning a MySQL->Postgres cutover. Covers the migration strategy (pgloader vs query-builder), the Laravel-specific behavior differences that silently break (case sensitivity, booleans, the id-sequence trap, raw SQL, GROUP BY strictness), and a verification checklist.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Laravel: MySQL -> PostgreSQL migration

The data moves fine. What breaks is the assumptions your app baked in over the years, because **MySQL is forgiving and Postgres is strict**. Every place you leaned on MySQL being lenient is a bug waiting on the other side. Treat a migration as an *audit of your app's lazy assumptions*, not a data transfer.

## Step 0 - The one test that surfaces half the problems

Before touching real data, point `php artisan migrate` at a **fresh empty Postgres database** and watch what throws. If every migration runs clean, your schema is genuinely database-agnostic. If it throws, you just found your MySQL-only assumptions for free.

```bash
# .env pointed at an empty pgsql db
php artisan migrate:fresh   # does the schema even build on Postgres?
```

Do not delete MySQL the day you switch. Keep it running for days/weeks until you're sure - cutovers get reverted.

## Step 1 - Move the data (pick one)
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add majdghithan/agent-skills/laravel-mysql-to-postgres@sha256:760a5dd3b94f5096

The line at the top of this page pins the label git:20260729.b363e32, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_qkwd5now4l2sr2cz.svg)](https://markdownregistry.com/a/art_qkwd5now4l2sr2cz)

3 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 1 version of this file, committed on Jul 29, 2026.

versioncommittedcommitsizeaudit
git:20260729.b363e32 latest2026-07-29 b363e32 5,714 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (5714 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

majdghithan/agent-skills · 8 stars · license MIT · pushed 2026-09-20 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_qkwd5now4l2sr2cz
GET https://markdownregistry.com/api/v1/resolve?ref=majdghithan/agent-skills/laravel-mysql-to-postgres
GET https://markdownregistry.com/api/v1/blob/760a5dd3b94f50965291ddf8b65b0006b36c4f6f4ddd172a9861180b9c749928

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from majdghithan/agent-skills

filament-plugin-development SKILL.md skill
majdghithan/agent-skills · skills/filament-plugin-development/SKILL.md · Build and publish custom Filament plugins (Filament is the Laravel admin-panel framework). Use when creating a Filament…
git:20260729.c006d55 · audit A · 8 stars
geo-llm-optimization SKILL.md skill
majdghithan/agent-skills · skills/geo-llm-optimization/SKILL.md · Generative Engine Optimization (GEO) - make a website citable and recommended INSIDE AI-assistant answers (ChatGPT…
git:20260729.b363e32 · audit A · 8 stars
lahja SKILL.md skill
majdghithan/agent-skills · skills/lahja/SKILL.md · Arabic dialects (لهجة) writing skill - write or rewrite Arabic in a specific spoken dialect with correct dialect…
git:20260920.538264f · audit A · 8 stars
laravel-architecture-review SKILL.md skill
majdghithan/agent-skills · skills/laravel-architecture-review/SKILL.md · Review a Laravel codebase's architecture and design, not just its types. Use when asked to audit a Laravel app, find…
git:20260729.8c02853 · audit A · 8 stars
laravel-filament SKILL.md skill
majdghithan/agent-skills · skills/laravel-filament/SKILL.md · Version-aware best practices for Filament (the Laravel admin-panel / TALL-stack framework by filamentphp), covering v1…
git:20260729.6c62a20 · audit A · 8 stars
laravel-mixpost SKILL.md skill
majdghithan/agent-skills · skills/laravel-mixpost/SKILL.md · Self-host and operate Mixpost (the open/self-hosted social-media scheduler by Inovector) inside a Laravel app -…
git:20260729.b363e32 · audit A · 8 stars
laravel-upgrade SKILL.md skill
majdghithan/agent-skills · skills/laravel-upgrade/SKILL.md · Upgrade a Laravel application across major versions safely (Laravel 8 -> 9 -> 10 -> 11 -> 12 -> 13), one hop at a time…
git:20260729.4bed2ca · audit A · 8 stars
livewire SKILL.md skill
majdghithan/agent-skills · skills/livewire/SKILL.md · Version-aware best practices for Laravel Livewire (Caleb Porzio's full-stack framework), covering v1 through v4. Use…
git:20260729.c006d55 · audit A · 8 stars
skill-authoring SKILL.md skill
majdghithan/agent-skills · skills/skill-authoring/SKILL.md · Author, structure, verify, and publish a high-quality agent skill (SKILL.md). Use whenever the user wants to "write a…
git:20260729.68e840f · audit A · 8 stars

Every file in majdghithan/agent-skills

Browse by kind, by grade A, or by owner.