fuzzy-matching
A pipeline for matching similar entities using PostgreSQL trigram pre-filtering and scoring.
Install
mkdir -p .claude/skills/fuzzy-matching && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/3894" && unzip -o skill.zip -d .claude/skills/fuzzy-matching && rm skill.zipInstalls to .claude/skills/fuzzy-matching
Activation
This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.
Multi-stage fuzzy matching pipeline for entity reconciliation. PostgreSQL trigram pre-filter, salient overlap check, and multi-factor similarity scoring.Key capabilities
- →Perform PostgreSQL trigram pre-filtering
- →Execute salient overlap checks
- →Calculate multi-factor similarity scores
- →Normalize text for consistent matching
- →Provide match recommendations based on confidence
How it works
The skill uses a three-stage pipeline: a fast database-level trigram filter, a quick salient word overlap check, and an expensive multi-factor similarity calculation to rank matches.
Inputs & outputs
When to use fuzzy-matching
- →Reconcile customer databases
- →Clean duplicate entries
- →Match entities across different sources
- →Perform fuzzy search on datasets
About fuzzy-matching
Performs entity reconciliation by applying a multi-factor matching strategy. It uses database-level trigram filtering followed by similarity checks to identify related records.
Multi-stage fuzzy matching pipeline for entity reconciliation. PostgreSQL trigram pre-filter, salient overlap check, and multi-factor similarity scoring.
When not to use it
- →When exact matching is sufficient
- →When the dataset is too small to benefit from indexing
Prerequisites
Limitations
- →Requires database-level indexing for performance
- →Normalization logic must be tuned for specific domains
- →Performance depends on the quality of the trigram index
How it compares
It uses a multi-stage approach to balance performance and accuracy, unlike simple single-factor string distance algorithms.
Compared to similar skills
fuzzy-matching side by side with the closest alternatives in the catalog.
| Skill | Installs | Updated | Safety | Difficulty |
|---|---|---|---|---|
| fuzzy-matching (this skill) | 8 | 6mo | No flags | Advanced |
| sql-queries | 18 | 5mo | No flags | Intermediate |
| sql-pro | 3 | 4mo | No flags | Advanced |
| postgres-hybrid-text-search | 1 | 4mo | No flags | Advanced |
Try saying
Example prompts that trigger this skill in your AI assistant.
More by dadbodgeoff
View all by dadbodgeoff →You might also like
sql-queries
anthropics
Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.). Use when writing queries, optimizing slow SQL, translating between dialects, or building complex analytical queries with CTEs, window functions, or aggregations.
sql-pro
sickn33
Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems. Use PROACTIVELY for database optimization or complex analysis.
postgres-hybrid-text-search
timescale
Use this skill to implement hybrid search combining BM25 keyword search with semantic vector search using Reciprocal Rank Fusion (RRF). **Trigger when user asks to:** - Combine keyword and semantic search - Implement hybrid search or multi-modal retrieval - Use BM25/pg_textsearch with pgvector together - Implement RRF (Reciprocal Rank Fusion) for search - Build search that handles both exact terms and meaning **Keywords:** hybrid search, BM25, pg_textsearch, RRF, reciprocal rank fusion, keyword search, full-text search, reranking, cross-encoder Covers: pg_textsearch BM25 index setup, parallel query patterns, client-side RRF fusion (Python/TypeScript), weighting strategies, and optional ML reranking.
whodb
clidey
Database operations including querying, schema exploration, and data analysis. Activates for tasks involving PostgreSQL, MySQL, MariaDB, SQLite, MongoDB, Redis, Elasticsearch, or ClickHouse databases.
timescaledb
2025Emma
TimescaleDB - PostgreSQL extension for high-performance time-series and event data analytics, hypertables, continuous aggregates, compression, and real-time analytics
data-engineering
mazelb
|