Home / majdghithan / agent-skills · skills/laravel-mysql-to-postgres/SKILL.md · GitHub

laravel-mysql-to-postgres skillA

laravel-mysql-to-postgres is agent-read markdown (skill) from majdghithan/agent-skills: 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..

Indexed from public GitHub and served as immutable, content-addressed versions. Install it pinned to an exact SHA-256 with the mdr CLI, and every file is verified against the hash recorded here before it reaches your agent. The deterministic audit below grades the latest version, and the same file always earns 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

Latest version
mdr add majdghithan/agent-skills/laravel-mysql-to-postgres@git:20260729.b363e32
Exact content
mdr add majdghithan/agent-skills/laravel-mysql-to-postgres@sha256:760a5dd3b94f5096

Pin to a label to follow the author's releases, or to a sha256 to freeze the exact bytes forever. Either way the resolved hash is written to mdr.lock, and mdr install reproduces it on any machine.

Badge

mdr badge

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

1 badge views in 30 days

Versions

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

Audit of the latest version

A  17 of 17 checks passed. Deterministic, no model, 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 · 7 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 agent 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.

More from majdghithan/agent-skills

filament-plugin-development 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 · 7 stars
geo-llm-optimization 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 · 7 stars
lahja 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 · 7 stars
laravel-architecture-review 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 · 7 stars
laravel-filament 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 · 7 stars
laravel-mixpost 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 · 7 stars
laravel-upgrade 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 · 7 stars
livewire 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 · 7 stars
skill-authoring 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 · 7 stars

Every file in majdghithan/agent-skills

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