Pinecone Vector Database Management in VS Code

Overview

Pinecone is a fully managed, cloud-native vector database designed for high-performance similarity search at scale. Highlights include:

• Fully managed: No servers to run; the control plane lives at api.pinecone.io and each index has its own data-plane host
• Serverless and pod-based indexes: Pay-as-you-go serverless indexes or dedicated pods
• Metadata filtering: Combine vector similarity with structured metadata filters ($eq, $gt, $in, …)
• Namespaces: Partition records within an index for multi-tenancy; each query targets a single namespace
• Simple data model: Each record has an id, a vector (values), and optional metadata

Pinecone is commonly used for semantic search, retrieval-augmented generation (RAG), recommendations, and AI assistants that need fast nearest-neighbour lookups over large vector sets.

How Pinecone maps into DBCode

Pinecone has two containers above records, so DBCode mirrors its MongoDB layout:

• A Pinecone index appears as a database (it owns the vector dimension and distance metric)
• A Pinecone namespace appears as a collection you can browse and search
• Each record has an id, a values vector, and metadata fields

Because queries in Pinecone never cross namespaces, browse and search always operate on a single namespace at a time.

Connecting

To connect to Pinecone in DBCode:

1. Open the DBCode Extension: Launch Visual Studio Code and open the DBCode extension.
2. Add a New Connection: Click on the “Add Connection” icon.
3. Complete the connection form: Select Pinecone as the database type and enter:
   • Your Pinecone API key (found in the Pinecone console). There is no host or port - Pinecone resolves index hosts automatically.
   • Optionally pick a default Index (you can also expand any index in the tree).
4. Connect: Click save to connect to your Pinecone project.
5. Start exploring: Expand an index to see its namespaces, inspect records, and run vector searches.

For detailed instructions, refer to the Connect article.

Pinecone Features in DBCode

DBCode brings the same browse-and-search workflow you already use for SQL and document databases to Pinecone:

• Index and namespace browsing: Navigate indexes (databases) and their namespaces (collections), and inspect the metadata shape
• Vector cell rendering: Vector columns are summarised inline (e.g. [float32×1536]) and expandable on click
• Vector search: Run nearest-neighbour searches with top-K, metadata filters, and a _score column
• Metadata editing: Edit metadata fields inline and delete records; the id and vector are read-only
• Search by text: Configure an Ollama model or DBCode AI to embed your query text on the fly (Pinecone has no usable server-side embedding for standard indexes)
• JS shell editor: Drop into a JavaScript editor and run the Pinecone client directly (client.search(...), client.browse(...), client.fetch(...), client.listIndexes())

Note

Browsing records uses Pinecone’s id listing, which is available on serverless indexes. On pod-based indexes, use vector search to explore records.

By using Pinecone with DBCode, you get a unified workspace for traditional and vector data without leaving VS Code.

For more information about Pinecone, check out Pinecone.