New: 98,000+ skills indexed from GitHub repos with 100+ stars · every skill safety-checkedBrowse top skillsTop skills
Esc to closeBrowse all skills
Submit a skillBrowse skills
Submit a skillBrowse skills

Agent skill

Psycopg2 Like Percent Escape

by divinevideo in divinevideo/divine-mobile

Fix psycopg2 "IndexError: tuple index out of range" when using LIKE with parameterized queries.

MPL-2.0Auto-check passedDatabases

Install Psycopg2 Like Percent Escape

skills CLI
$ npx skills add divinevideo/divine-mobile --skill psycopg2-like-percent-escape -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install divinevideo/divine-mobile psycopg2-like-percent-escape --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/divinevideo/divine-mobile.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.agents/skills/psycopg2-like-percent-escape .claude/skills/psycopg2-like-percent-escape && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
psycopg2-like-percent-escape
GitHub stars
266
Token cost
~1.1k tokens
SKILL.md length
300 words
Files
1
Skills in repo
103
Repo updated
First seen
Licence
MPL-2.0

At a glance

Fix psycopg2 "IndexError: tuple index out of range" when using LIKE with parameterized queries.

  • Works in 2 steps: SQL LIKE wildcard (e.g., '%pattern%') → psycopg2's parameter placeholder marker…
  • Cursor.execute() fails with IndexError on a query containing LIKE %pattern%
  • SKILL.md covers Problem, Context / Trigger Conditions, Solution and Verification, plus 4 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Psycopg2 Like Percent Escape is an agent skill from divinevideo/divine-mobile. Fix psycopg2 "IndexError: tuple index out of range" when using LIKE with parameterized queries. Use when: (1) cursor.execute() fails with IndexError on a query containing LIKE '%pattern%', (2) SQL LIKE wildcards conflict with psycopg2 %s parameter placeholders, (3) Query works in psql but fails in Python. The % character has dual meaning: SQL LIKE wildcard AND psycopg2's parameter substitution marker.

Its SKILL.md is about 1.1k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Databases, covering SQL. It works with SQL, PostgreSQL and Python. The licence is MPL-2.0.

When your agent uses it

  • Cursor.execute() fails with IndexError on a query containing LIKE %pattern%
  • SQL LIKE wildcards conflict with psycopg2 %s parameter placeholders
  • Query works in psql but fails in Python

Example prompts

  • “IndexError: tuple index out of range”
  • “%pattern%”
  • “/psycopg2-like-percent-escape”

Requirements

  • Python 3

Workflow steps

2 steps, taken from the first numbered list in SKILL.md.

  1. SQL LIKE wildcard (e.g., '%pattern%')
  2. psycopg2's parameter placeholder marker (e.g., %s)

What it can do on your machine

Read from SKILL.md and the folder at commit c3d6f7e. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md (its code samples are python).

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    Links to these hosts (documentation or services it may open):

    • psycopg.org
    • postgresql.org
    • github.com

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Psycopg2 Like Percent Escape loads about 1.1k tokens when it runs. Until then it costs about 108 tokens; SKILL.md has 300 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~108
When it runs · the whole SKILL.md, loaded when a task matches
~1.1k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from divinevideo/divine-mobile at commit c3d6f7e, republished under its MPL-2.0 licence (© divinevideo). 300 words, ~1,141 tokens.

Download SKILL.mdSave it as .claude/skills/psycopg2-like-percent-escape/SKILL.md (or your agent's skills folder).
name
psycopg2-like-percent-escape
description
Fix psycopg2 "IndexError: tuple index out of range" when using LIKE with parameterized queries. Use when: (1) cursor.execute() fails with IndexError on a query containing LIKE '%pattern%', (2) SQL LIKE wildcards conflict with psycopg2 %s parameter placeholders, (3) Query works in psql but fails in Python. The % character has dual meaning: SQL LIKE wildcard AND psycopg2's parameter substitution marker.
author
Claude Code
version
1.0.0
date
2026-01-29

psycopg2 LIKE Clause Percent Sign Escaping

Problem

When using psycopg2 with parameterized queries containing SQL LIKE patterns, the % character causes conflicts. The % is used both as:

  1. SQL LIKE wildcard (e.g., '%pattern%')
  2. psycopg2's parameter placeholder marker (e.g., %s)

This results in confusing errors like IndexError: tuple index out of range because psycopg2 interprets %c in %cdn as a format specifier.

Context / Trigger Conditions

  • IndexError: tuple index out of range from cursor.execute()
  • Query contains hardcoded LIKE pattern: WHERE column LIKE '%something%'
  • Query also uses %s parameters for other values
  • Query works in psql or pgAdmin but fails in Python

Example failing code:

python
cursor.execute("""
    SELECT * FROM vines
    WHERE url LIKE '%cdn.vine.co%'
    LIMIT %s OFFSET %s
""", (1000, 0))
# IndexError: tuple index out of range

Solution

Option 1: Escape % with %% (for static patterns)

Double the percent signs in hardcoded LIKE patterns:

python
cursor.execute("""
    SELECT * FROM vines
    WHERE url LIKE '%%cdn.vine.co%%'
    LIMIT %s OFFSET %s
""", (1000, 0))

The cleaner approach - pass the entire LIKE pattern as a parameter:

python
pattern = '%cdn.vine.co%'
cursor.execute("""
    SELECT * FROM vines
    WHERE url LIKE %s
    LIMIT %s OFFSET %s
""", (pattern, 1000, 0))

This is the recommended approach because:

  • No escaping confusion
  • Pattern can be dynamically constructed
  • Follows parameterized query best practices
Option 3: Use psycopg2.sql module for complex cases

For dynamic SQL construction:

python
from psycopg2 import sql

query = sql.SQL("""
    SELECT * FROM {table}
    WHERE url LIKE %s
""").format(table=sql.Identifier('vines'))

cursor.execute(query, ('%cdn.vine.co%',))

Verification

After applying the fix:

  1. Query executes without IndexError
  2. Results correctly match the LIKE pattern
  3. Other %s parameters are still substituted correctly

Example

Before (broken):

python
def get_vines_by_cdn(db, limit, offset):
    cursor = db.cursor()
    cursor.execute("""
        SELECT vine_id, url FROM discovered_vines
        WHERE url LIKE '%cdn.vine.co%'
        ORDER BY created_at
        LIMIT %s OFFSET %s
    """, (limit, offset))
    return cursor.fetchall()

After (fixed with Option 1):

python
def get_vines_by_cdn(db, limit, offset):
    cursor = db.cursor()
    cursor.execute("""
        SELECT vine_id, url FROM discovered_vines
        WHERE url LIKE '%%cdn.vine.co%%'
        ORDER BY created_at
        LIMIT %s OFFSET %s
    """, (limit, offset))
    return cursor.fetchall()

After (fixed with Option 2 - recommended):

python
def get_vines_by_cdn(db, limit, offset):
    cursor = db.cursor()
    cdn_pattern = '%cdn.vine.co%'
    cursor.execute("""
        SELECT vine_id, url FROM discovered_vines
        WHERE url LIKE %s
        ORDER BY created_at
        LIMIT %s OFFSET %s
    """, (cdn_pattern, limit, offset))
    return cursor.fetchall()

Notes

  • This issue only affects parameterized queries with %s placeholders
  • Raw SQL strings without parameters don't have this problem
  • The %% escape only works when the query uses psycopg2's parameter substitution
  • Django's ORM handles this automatically; this is a raw SQL issue
  • psycopg3 uses $1, $2 style placeholders, avoiding this conflict entirely
  • Searching for literal % in data requires additional escaping with ESCAPE clause
  • Similar issues can occur with _ (single character wildcard) if using %_ pattern

References

© divinevideo, MPL-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in .agents/skills/psycopg2-like-percent-escape of divinevideo/divine-mobile.

Open the folder on GitHubat commit c3d6f7e

Compare with similar skills

Psycopg2 Like Percent Escape next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Psycopg2 Like Percent Escape compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Psycopg2 Like Percent Escape this skilldivinevideo/divine-mobile266—~1.1kAutomated safety check: PassMPL-2.0
Chdb SQLvemetric/vemetric3951 repos~1.2kAutomated safety check: PassApache-2.0
Safe SQL Executionsupabase/supabase111k—~4.2kAutomated safety check: PassApache-2.0
Citus Backportcitusdata/citus13k—~3.2kAutomated safety check: PassAGPL-3.0
SQL Database Support for pRESTprest/prest4.6k—~1.6kAutomated safety check: PassMIT
Mz BenchmarkMaterializeInc/materialize6.4k—~2.8kAutomated safety check: PassCustom licence

Similar skills

  • Chdb SQL

    vemetric/vemetric

    A skill your agent uses when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse…

    395 GitHub starsUsed in 1 repo~1.2k tokens
    DatabasesAuto-check passed

  • Safe SQL Execution

    supabase/supabase

    Official

    A skill your agent uses whenever code will build, return, fetch, or execute SQL that runs against a user's real Postgres database — even when the request reads like an ordinary feature or bug fix…

    111k GitHub stars~4.2k tokensUpdated yesterday
    DatabasesAuto-check passed

  • Citus Backport

    citusdata/citus

    Backport one or more merged citusdata/citus main commits/PRs onto the active release branches.

    13k GitHub stars~3.2k tokensUpdated 2 days ago
    DatabasesAuto-check passed

  • SQL Database Support for pREST

    prest/prest

    Guides classifying, gap-analyzing and scaffolding support for a new SQL database in pREST, from Postgres-compatible variants to entirely new dialects.

    4.6k GitHub stars~1.6k tokensUpdated yesterday
    DatabasesAuto-check passed

  • Mz Benchmark

    MaterializeInc/materialize

    Add/modify/debug Materialize perf benchmark scenarios. An agent skill from MaterializeInc/materialize.

    6.4k GitHub stars~2.8k tokensUpdated today
    DatabasesAuto-check passed

  • Schema Exploration

    timescale/pg-aiguide

    Explore an existing PostgreSQL database before answering questions about its data or writing SQL.

    1.9k GitHub stars~1.1k tokensUpdated 3 days ago
    DatabasesAuto-check passed

More from divinevideo/divine-mobile

All 103 skills in this repo

  • Argocd Externalsecret Namespace Permission

    divinevideo/divine-mobile

    Fix ArgoCD ExternalSecret deployment failing with "namespace X is not permitted in project Y".

    266 GitHub stars~931 tokensUpdated today
    Auto-check passed

  • Art Direct

    divinevideo/divine-mobile

    Art direction for any content — reads text, PDF, Word, HTML, PPT, then proposes 2-3 creative directions with photography style, mood, and visual language.

    266 GitHub stars~4.8k tokensUpdated today
    Auto-check passed

  • Async Await Null Race Condition

    divinevideo/divine-mobile

    Fix "Null check operator used on a null value" errors when an object is set to null during an async await.

    266 GitHub stars~881 tokensUpdated today
    Auto-check passed

  • AWS V4 Signing Custom Headers Gcs

    divinevideo/divine-mobile

    Add custom metadata headers (x-amz-meta-) to AWS v4 signed requests for GCS S3-compatible API.

    266 GitHub stars~1k tokensUpdated today
    Auto-check passed

  • Bash Herestring Newline Secrets

    divinevideo/divine-mobile

    Fix password/secret authentication failures caused by trailing newlines when creating Google Cloud secrets (or similar) with bash here-strings.

    266 GitHub stars~791 tokensUpdated today
    Auto-check passed

  • Blossom Content Addressed URL Filtering

    divinevideo/divine-mobile

    Fix silent video/media processing failures caused by URL extraction code that filters on file extensions (.mp4, .webm, .webp).

    266 GitHub stars~1.1k tokensUpdated today
    Auto-check passed

Works with

Categories

Questions about Psycopg2 Like Percent Escape

What does Psycopg2 Like Percent Escape do?

Fix psycopg2 "IndexError: tuple index out of range" when using LIKE with parameterized queries. Psycopg2 Like Percent Escape is an agent skill from divinevideo/divine-mobile. Fix psycopg2 "IndexError: tuple index out of range" when using LIKE with parameterized queries.

When should I use Psycopg2 Like Percent Escape?

Psycopg2 Like Percent Escape fits situations like: Cursor.execute() fails with IndexError on a query containing LIKE %pattern%; SQL LIKE wildcards conflict with psycopg2 %s parameter placeholders; query works in psql but fails in Python.

How do I install Psycopg2 Like Percent Escape in Claude Code?

Run `npx skills add divinevideo/divine-mobile --skill psycopg2-like-percent-escape -a claude-code`. Or copy the skill folder (.agents/skills/psycopg2-like-percent-escape in divinevideo/divine-mobile) into .claude/skills/psycopg2-like-percent-escape in your project. Claude Code loads it when a task matches its description.

How do I install Psycopg2 Like Percent Escape in Codex?

Run `npx skills add divinevideo/divine-mobile --skill psycopg2-like-percent-escape -a codex`. Or copy the skill folder (.agents/skills/psycopg2-like-percent-escape in divinevideo/divine-mobile) into .agents/skills/psycopg2-like-percent-escape in your project. Codex loads it when a task matches its description.

Can I use Psycopg2 Like Percent Escape in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add divinevideo/divine-mobile --skill psycopg2-like-percent-escape -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/psycopg2-like-percent-escape, .gemini/skills/psycopg2-like-percent-escape, .github/skills/psycopg2-like-percent-escape and .opencode/skills/psycopg2-like-percent-escape in your project.

What does Psycopg2 Like Percent Escape need to run?

SKILL.md names no scripts, command-line tools or credentials: Psycopg2 Like Percent Escape is instructions for the agent only. Our summary lists: Python 3.

Does Psycopg2 Like Percent Escape access the network?

SKILL.md names 3 domains. As links in the text: psycopg.org, postgresql.org and github.com. This is read from the text; nothing was executed.

Is Psycopg2 Like Percent Escape safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Psycopg2 Like Percent Escape use?

Psycopg2 Like Percent Escape is published under the MPL-2.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Psycopg2 Like Percent Escape use?

About 1.1k tokens (SKILL.md is roughly 4.6k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Psycopg2 Like Percent Escape?

Skills that share tags, products or a category with Psycopg2 Like Percent Escape: Chdb SQL (vemetric/vemetric, 395 stars), Safe SQL Execution (supabase/supabase, 111k stars), Citus Backport (citusdata/citus, 13k stars) and SQL Database Support for pREST (prest/prest, 4.6k stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Psycopg2 Like Percent Escape?

divinevideo (a GitHub organization) maintains it in divinevideo/divine-mobile, which has 266 GitHub stars. The repository holds 103 skills in this directory. The repository was last updated on October 10, 2026.

Source: divinevideo/divine-mobile on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.