Skip to main content
Glama
RaviSenjaliya

askDB

by RaviSenjaliya
OverviewSchemaRelated ServersScoreDiscussions
JavaScript
Hybrid

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
TOP_KNoChunks retrieved per search.8
ELICITNoPrompt the user directly when the client supports MCP elicitation.true
DB_FIELDSNoCandidate metadata keys for database fields.
MAX_TOP_KNoMaximum chunks retrieved per search.30
MIN_SCORENoExtra absolute score floor; 0 disables it.0
MAX_TABLESNoTables rendered in one answer.4
EMBED_MODELNoEmbedding model. Must match the model used to upsert the index.multilingual-e5-large
SQL_DIALECTNoSQL dialect hint passed to the model.MySQ L
TEXT_FIELDSNoCandidate metadata keys for text fields, tried in order.
CACHE_TTL_MSNoIn-process TTL cache for searches, fetches and inventory; 0 disables.600000
TABLE_FIELDSNoCandidate metadata keys for table fields.
AMBIGUITY_GAPNoBiggest score drop in the top results below which the ranking counts as flat. Raise to be asked more often.0.015
MAX_CANDIDATESNoLength of the shortlist.8
MCP_AUTH_TOKENNoRequired when hosted; unused over stdio. Bearer token for /mcp endpoint.
PINECONE_INDEXNoPinecone index name.ask-db
ASK_WHEN_UNSURENoSet to false to always answer with the best guess.true
LIST_SCAN_LIMITNoCap on list_tables scanning.1000
DEFAULT_DATABASENoScope every lookup to one database, e.g. speed_core_live.
PINECONE_API_KEYYesRequired. Your Pinecone API key.
SCAN_CONCURRENCYNoRecord batches fetched in parallel while scanning.6
INVENTORY_WAIT_MSNoHow long a search waits for a table scan still warming up; 0 never waits.3000
MAX_LISTED_TABLESNoNames printed by list_tables before asking for a filter.120
MAX_RESPONSE_CHARSNoWhole-response cap in characters.7000
PINECONE_NAMESPACENoPinecone namespace. Empty for default namespace.
MAX_CHARS_PER_TABLENoPer-table DDL cap in compact detail.1400

Instructions

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Capabilities

Features and capabilities supported by this server

Protocol revision2025-11-25

CapabilityDetails
tools
{
  "listChanged": true
}

Tools

Functions exposed to the LLM to take actions

NameDescription
search_schemaA

Semantic search over the database schema stored in Pinecone. Call this FIRST for any text-to-SQL request: pass the user question verbatim and you get back the relevant tables, columns, types and relationships to write the query against.

get_table_schemaA

Fetch the full stored DDL for one or more tables by exact name. Use after search_schema when you need every column of a table, or when the user named the table.

list_tablesA

Inventory of every table in the schema index, grouped by database, plus the index configuration. Use it to orient yourself, or when search_schema comes back empty.

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/RaviSenjaliya/askDB-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server