skills.rest
matejformanek
matejformanekCOMMUNITY
Explore all skills by this author →
GitHub

collation-provider

Manage PostgreSQL collation provider dispatch and multibyte encoding conversion.

Updated Jun 1, 2026
Search Tags:#postgresql#encoding#collation#locale#icu#database-internals
One-click install
npx skills add https://github.com/matejformanek/postgres-claude --skill collation-provider
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: collation-provider
Source: https://github.com/matejformanek/postgres-claude/tree/main/.claude/skills/collation-provider
Command: npx skills add https://github.com/matejformanek/postgres-claude --skill collation-provider

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill resolves complex issues surrounding PostgreSQL text comparison, sorting, and encoding, preventing silent data corruption and index mismatches caused by OS or library upgrades.

Core Features & Use Cases

  • Provider Management: Navigate the differences between builtin, ICU, and libc collation providers to ensure deterministic sorting.
  • Encoding & Locale Debugging: Diagnose multibyte string handling, client-server encoding mismatches, and collation versioning issues.
  • Use Case: When an index scan returns incorrect results after an OS upgrade, use this skill to identify the collation version mismatch and perform the necessary REINDEX operations.

Quick Start

Use the collation-provider skill to analyze the current collation dispatch configuration and identify potential version mismatches in the database.

Frequently Asked Questions about collation-provider

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I fix PostgreSQL index scan errors after an OS upgrade?▼

PostgreSQL index scan errors after an OS upgrade are typically caused by collation version mismatches. This skill diagnoses the locale-dependent sorting changes and identifies the necessary REINDEX operations to restore index stability.

What is the difference between ICU and libc collation providers in PostgreSQL?▼

ICU and libc are distinct PostgreSQL collation providers with different sorting behaviors. This skill navigates the differences between builtin, ICU, and libc providers to help you manage deterministic sorting and avoid silent data corruption.

How do I debug PostgreSQL client-server encoding mismatches and multibyte string issues?▼

Debugging PostgreSQL client-server encoding mismatches involves analyzing multibyte encoding conversion logic. This skill diagnoses server-client encoding translation errors and facilitates debugging of locale-dependent text handling.

When do I need to track collation versions in PostgreSQL?▼

Tracking PostgreSQL collation versions is necessary when OS or library upgrades alter text comparison rules. This skill identifies collation version mismatches that cause silent data corruption and provides guidance for performing REINDEX operations.

Can I use builtin collation providers for deterministic sorting in PostgreSQL?▼

Yes, builtin collation providers support deterministic sorting in PostgreSQL. This skill analyzes the current collation dispatch configuration and integrates builtin, ICU, and libc providers to ensure consistent text comparison behavior.

Related Skills

Explore More Software Engineering Skills→
Impertio-StudioImpertio-Studio
2

mariadb-core-defaults-and-sql-modes

Configure MariaDB defaults, SQL modes, charset, and collation settings.

Official
Advanced
msichtermanmsichterman

upgrading-expo

Plan and execute Expo SDK upgrades with dependency synchronization and validation.

Community
Intermediate
sayasaya8039sayasaya8039
2

database-migrations

Create zero-downtime migration plans for PostgreSQL and MySQL schema changes.

Community
Advanced
cosmixcosmix
53

i18n

Implement internationalization with locale-aware formatting, pluralization, and RTL support.

Community
Intermediate