Vant skill postgresql

Skill dhaupin/vant/models/public/skills/vant-skill-postgresql

Vant: Durable AI memory + cold storage + runtime for agents, with generational evolution, stored passively via GitHub. Built for long-running autonomous sessions, using file based persistence.

Install

npx -y skills add dhaupin/vant --skill vant-skill-postgresql

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

7 stars7 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

What its author says it does

Copied from the file, not written here

Database operations.

The file declares its own license as MIT. That is the author’s claim about this one file, and it is not the same thing as the license GitHub reports for the repository, which is listed with the other numbers below.

SKILL.md

1.1 KB, 297 tokens by cl100k_base, as published. Nobody here has run it

PostgreSQL

Database operations.

When To Use

Relational data
Complex queries
ACID compliance

What To Do

1. Connect

// pg
import { Pool } from 'pg'

const pool = new Pool({
  connectionString: 'postgres://user:pass@localhost:5432/db'
})

const client = await pool.connect()

2. Common Queries

Query	What
SELECT	Read data
INSERT	Create data
UPDATE	Modify data
DELETE	Remove data

3. Patterns

-- Basic
SELECT * FROM users WHERE id = 1

-- Join
SELECT u.name, o.total
FROM users u
JOIN orders o ON u.id = o.user_id

-- Aggregate
SELECT COUNT(*), SUM(total) FROM orders

4. Migrations

# node-pg-migrate
npx node-pg-migrate create add_users
npx node-pg-migrate up

Output

## PostgreSQL

| Query | Rows | Time |
|-------|------|------|
| SELECT | [n] | [n]ms |

### Tables
- [list]

Role: PostgreSQL DBA
Input: SQL, schema
Output: Data

Relational data.

Gives 0 of the 12 instructions most databases sql skills give in 297 tokens

Counted across 589 of the 662 authors here whose files we hold, read 2026-08-07

use parameterized queriesin 37 of 589, across 34 files
use timestamptz for timestampsin 30 of 589, across 14 files
index foreign keysin 29 of 589, across 18 files
create indexes concurrentlyin 29 of 589, across 24 files
use numeric type for moneyin 25 of 589, across 8 files
use cursor pagination instead of offsetin 24 of 589, across 17 files
select only required columnsin 24 of 589, across 20 files
add indexes manually on foreign key columnsin 22 of 589, across 12 files
normalize to third normal formin 19 of 589, across 10 files
configure connection poolingin 19 of 589, across 17 files
put equality columns before range columns in indexesin 18 of 589, across 10 files
read individual rule files for detailed explanationsin 18 of 589, across 4 files

Said here and by no other author read

use select to read data
use insert to create data
use delete to remove data
use joins to combine table data
create database migrations using node-pg-migrate
apply pending database migrations

Grouped from the skills themselves: near-identical wordings counted once, and counted by distinct author, so one author publishing three of these counts once. Length counted with cl100k_base; the agent that loads this file may tokenize it differently.