Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

Get Started Free →

PostgreSQL数字去除尾随零及小数点 — measured AI agent skill | DecimalAI

ecnu-icalk/PostgreSQL数字去除尾随零及小数点

NewSkillScoreMaintained

在PostgreSQL中格式化数字显示，去除小数点后的尾随零，并在小数点后无数字时去除小数点。

Databy ecnu-icalk

Links this skill to your agents and keeps it current with the author’s updates.

Automatic

Coding pack

1 · One-time — install the CLI (docs ↗)

pip install decimalai

2 · Get the skill — writes .claude/skills/ecnu-icalk-postgresql/SKILL.md

decimalai skills pull ecnu-icalk-postgresql --out .claude/skills/

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/ecnu-icalk-postgresql/SKILL.md https://app.decimal.ai/s/ecnu-icalk-postgresql/SKILL.md

Raw file: /s/ecnu-icalk-postgresql/SKILL.md ↗ · machine-readable summary at /s/ecnu-icalk-postgresql.json ↗

In productionGlobal

how this skill behaves on real traffic · last 30 days

No production data for this skill yet — usage numbers appear here once agents start running it.

Anonymized aggregate across every org using this skill — proof from real production use, not a demo.

Does this skill help? · Benchmark: with vs. withoutsign in to run this on your agents

22 test cases from the publisher’s eval.yaml · each run twice on gemini-3.6-flash — with the skill injected, then without · last run 3h ago

Yes — +5% lift-1% tokens0% turns100% of whole cases pass with skill (22/22)

Test case	Without → With	Effect	Δ tokens	Δ turns
case-02	✗→✓	▲ Improved	32%	0%
case-11	✓→✓	＝ Same ✓	33%	0%
case-01	✓→✓	＝ Same ✓	-48%	0%
case-03	✓→✓	＝ Same ✓	-8%	0%
case-04	✓→✓	＝ Same ✓	-25%	0%

Showing 5 of 22 cases

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

0 critical · 0 warning · 0 info — scanner v4 — 8/3/2026

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

ecnu-icalk / autoskill

SkillBank/ConvSkill/chinese_gpt3.5_8/postgresql%E6%95%B0%E5%AD%97%E5%8E%BB%E9%99%A4%E5%B0%BE%E9%9A%8F%E9%9B%B6%E5%8F%8A%E5%B0%8F%E6%95%B0%E7%82%B9/SKILL.md

View on GitHub ↗

Imported 8/3/2026Version v1

Skill contents

SKILL.md

PostgreSQL数字去除尾随零及小数点

在PostgreSQL中格式化数字显示，去除小数点后的尾随零，并在小数点后无数字时去除小数点。

Prompt

Role & Objective

你是一个PostgreSQL SQL生成助手。你的任务是根据用户提供的表名和列名，生成能够格式化数字显示的SQL语句。

Operational Rules & Constraints

必须去除小数点后面的所有尾随零（0）。
如果去除尾随零后，小数点后面没有数字了，必须把小数点也去掉。
必须符合以下转换示例：

1.00 变成 1
1.010 变成 1.01
10 变成 10

Communication & Style Preferences

直接提供可执行的SQL代码，通常涉及类型转换或字符串处理函数。

Triggers

pgsql小数点后面有0把0去掉
postgresql去除尾随零
格式化数字去掉小数点后的0
去除数字末尾的0和小数点

Want to see if ecnu-icalk/PostgreSQL数字去除尾随零及小数点 would activate on your phrasing? Try it before you install — no LLM call, no signup.

Other measured skills in the registry, with their headline benchmark lift.