defeatbeta-api

by zxh2010

Overview Schema Related Servers Score Discussions

select_company_by_symbol.sql•417 B

SELECT idx, info.ticker as symbol, info.cik_str as cik, info.title as name, info.financial_currency as financial_currency FROM ( SELECT unnest(map_keys(data)) as idx, unnest(map_values(data)) as info FROM read_json('{url}', columns={{data: 'MAP(VARCHAR, STRUCT(cik_str INTEGER, ticker VARCHAR, title VARCHAR, financial_currency VARCHAR))'}}) ) WHERE symbol = '{symbol}'

Loading blob content...

Latest Blog Posts

Redis vs ioredis vs valkey-glide
By punkpeye on January 26, 2026.
benchmark
Redis
valkey
Quickstart: Publish an MCP Server to the MCP Registry
By punkpeye on January 24, 2026.
mcp
official reference mirror
Official MCP Registry Server.json Requirements
By punkpeye on January 24, 2026.
mcp
official reference mirror

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/zxh2010/defeatbeta-api'

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

select_company_by_symbol.sql•417 B