Synaptic SkillsSynapticSkills
MarketplaceSkill GraphCriar SkillMCP ServerPlataformaEnterprise
v0.1.0-beta
Voltar ao Marketplace
AgentsMédio

pgvector Semantic Search

portimescale·timescale· v1.0.0 · atualizado em 2026-04-11
85
Score

pgvector setup and best practices for semantic search with text embeddings in PostgreSQL

pgvectorsemantic-searchpostgresqlvector-embeddingshnswivfflatrag
Linguagens
SQL
0Stars
0Forks
0Usos
Fork

Documento do Skill

SKILL.mdpgvector-semantic-search/workflow
1
Assess Requirements: — Determine dataset size, performance goals (latency, recall), and filtering needs.
2
Choose Data Type: — Select `halfvec(N)` for embeddings, matching the embedding dimension.
3
Index Selection: — Default to HNSW for most workloads. Consider IVFFlat for write-heavy scenarios.
4
Configure Index: — Tune HNSW parameters (`m`, `ef_construction`, `ef_search`) based on dataset size and performance targets.
5
Implement Query Pattern: — Use `ORDER BY embedding <=> $1::halfvec(N) LIMIT k` with explicit casting.
6
Filtering Strategy: — Choose appropriate filtering based on selectivity (B-tree index, partial index, partitioning, iterative scan).
7
Monitor Performance: — Track latency, recall, and resource utilization under realistic load.
8
Adjust Configuration: — Iterate on parameters and strategies based on monitoring data.

Telemetria de Agentes

Execuções
0
total
Taxa de Sucesso
0%
últimos 30d
Latência Média
0.0s
p50
Alucinação
0.0%
detecção
Tokens Entrada
0
avg 0/exec
Tokens Saída
0
avg 0/exec

Uso por Plataforma

Skills Relacionados

Similar aMemory Notes
60%
Hebbian Synapse
Composite0.600
w = 0.3·α + 0.5·β + 0.2·γ
80
Similar aLiterature Review
60%
Hebbian Synapse
Composite0.600
w = 0.3·α + 0.5·β + 0.2·γ
79
Similar aMemOS Cloud Server Skill
60%
Hebbian Synapse
Composite0.600
w = 0.3·α + 0.5·β + 0.2·γ
77

Árvore do Skill

pgvector Semantic Search
pgvector-semantic-search
Fases Cognitivas7
1.SENSE
2.CONTEXTUALIZE
3.HYPOTHESIZE
4.EVALUATE
5.RECOMMEND
6.ACT
7.REFLECT
Triggers8
set up pgvector for semantic searchtune pgvector for optimal performanceoptimize pgvector for large datasetsimplement vector similarity search in postgresconfigure hnsw index in pgvectoruse binary quantization with pgvectorimprove pgvector query performancefilter vector search results in pgvector

Avaliar este Skill

Score Breakdown

⭐Avaliação Humana0%
🤖Sucesso de Agentes0%
🕐Atualidade100%
🔗Saúde de Dependências100%
🕸️Centralidade no Grafo0%
🛡️Segurança50%
CompositeScore = α·Humano + β·Agente + γ·Recência + δ·Deps + ε·Centralidade + ζ·Segurança

Instalação

$ synaptic mcp download pgvector-semantic-search
$ synaptic skills detail pgvector-semantic-search
$ synaptic skills live pgvector-semantic-search

Dependências

pgvector

Links

GitHub Repository