Menu
Postgres support — asyncpg client, schema-aware binder, PgQueryTool surface. Use when querying postgres from a tool, modifying the binder, or adding a new DB engine.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Router for any non-trivial echo-sdk task. Maps user intent to the right module skill and diagram. Invoke FIRST for any change to src/echo/ before reaching for a specific module skill.
Recipe for adding a new provider (LLM, transcriber, eval, prompt). Use whenever adding Cohere, Mistral, Deepgram, Phoenix, Promptlayer, etc. — anything that plugs into an existing get_*() factory.
End-to-end recipe for defining a Skill bundle and wiring it into a GenericAgent with the right activation mode and tool registry. Use when extending agent capability via swappable skills rather than baking tools in.
Building agents with BaseAgent / GenericAgent, including skill registration, activation modes (llm vs manual), and system-prompt composition. Use when editing src/echo/agents/ or building a new agent subclass.
Audio transcription provider abstraction (Gemini, EkaCare). Use when transcribing audio, adding a new transcriber, or shaping AudioInput.
Evaluation provider abstraction for dataset experiments (Langfuse today). Use when running an experiment, adding a new eval backend, or wiring evals into CI.
| name | echo-sdk-databases |
| description | Postgres support — asyncpg client, schema-aware binder, PgQueryTool surface. Use when querying postgres from a tool, modifying the binder, or adding a new DB engine. |
src/echo/databases/postgres/
client.py — async client around asyncpg.binder.py — schema → Python type mapping; converts query results to typed records.config.py — PostgresConfig (DSN, pool size, timeouts).PgQueryTool exposed via echo.tools — wraps the client as a BaseTool.asyncpg is async-native. Always await. Never use psycopg2 in this SDK.PostgresConfig for high-throughput hosts.async with or call await client.close() in finally — leaked connections accumulate.asyncpg uses $1, $2, ...asyncpg is an extra (echo[postgres]). Guard imports.PgQueryTool for agentsPostgresClient and exposes a JSON-schema query interface to the LLM.system_context.tool_context (e.g., workspace_id) — not in the LLM-visible schema.examples/ and tests/test_postgres_binder.py.databases/ (e.g., mysql/).client / binder / config triad.BaseTool only if agent-callable.pyproject.toml.Record to the LLM → use the binder, return plain dicts.[[echo-sdk-tools]], [[python-async-discipline]], [[python-memory-safety]]