sql2json: Python CLI tool to run queries against sqltatabases and convert the results to json, csv, excel in the command

by fsistemas · Agent Tool · ★ 55

Last updated: · Indexed by AgentSkillsHub · Auto-synced every 8h

How to install sql2json

pip install sql2json
pip install "sql2json[postgres]"   # psycopg2-binary

Taken from the project's README on GitHub.

Security audit verdict: SAFE · quality 72/100

None of the 42 rules matched — no credential harvesting, no data exfiltration, no curl-pipe-shell installer. Scanned against 42 published rules built on the SlowMist agent-security taxonomy, refreshed every 8 hours.

The quality score combines nine heuristic checks of the repo and its README: completeness, clarity, specificity, examples, structure, agent readiness, step-by-step content, instruction quality and security notes. It rates how well the project explains itself to an agent, not the code.

automationclicommand-line-toolconvertercsvdatabaseexcelexportjsonmysql

Quick Facts

Stars55
Forks11
LanguagePython
CategoryAgent Tool
LicenseMIT
Quality Score72/100
Last Updated2026-07-01
Created2019-12-21
Platformscli, python
Est. Tokens~17k

About sql2json

sql2json Run SQL queries and get JSON (or CSV) on stdout — pipe it anywhere. connects to any SQLAlchemy-supported database, executes a query, and writes the results as JSON to standard output. No server, no framework, no boilerplate.

Compatible Skills

These tools work well together with sql2json for enhanced workflows:

  • exstruct — semantic(0.27)+complementary+rare_topics+same_lang+similar_pop+shared_platform (64%)
  • strimzi-kafka-cli — semantic(0.28)+complementary+rare_topics+same_lang+similar_pop+shared_platform (59%)
  • mcp-excel-server — semantic(0.24)+complementary+rare_topics+same_lang+similar_pop+shared_platform (58%)

sql2json alternative? Top 6 similar tools

Looking for a sql2json alternative? If you're comparing sql2json with other agent tool tools, these 6 projects are the closest alternatives on Agent Skills Hub — ranked by topic overlap, star count, and community traction.

  • python-substack by ma2za · ⭐ 182

    Write and safely manage Substack drafts from Markdown with Python, CLI, and MCP.

  • MCP-PostgreSQL-Ops by call518 · ⭐ 164

    🐘 Give AI assistants full PostgreSQL DBA superpowers — 30+ tools for performance analysis, bloat detection, l

  • slowql by makroumi · ⭐ 140

    SQL static analyzer for performance, security, compliance and cost. 272 rules. Completely offline. Works in C

  • AutoRedTeam-Orchestrator by Coff0xc · ⭐ 263

    MCP-native security automation workbench (SDK + CLI + MCP) — authorized testing + static AI/MCP attack-surface

  • langchain_data_agent by eosho · ⭐ 236

    NL2SQL - Ask questions in plain English, get SQL queries and results. Powered by LangGraph.

  • douban-cli by Marvae · ⭐ 218

    豆瓣命令行工具 + AI Agent Skill:查电影、剧集、图书和 Top250,导出备份豆瓣观影/读书记录,让 AI 放心地标记评分 | Douban CLI for movies, books & your ra

More Agent Tool Tools

Explore other popular agent tool tools:

View all Agent Tool tools →

Popular Python Agent Tools

How this security grade is produced

Grades come from a rule-based scan built on the SlowMist agent-security taxonomy: 42 published rules, covering credential harvesting, data exfiltration, curl | sh installers and more. It is a first-layer scan, not a manual audit — we say so rather than overstate it.

The scale of the problem is documented independently: Liu et al. (2026), in a study of 31,132 agent skills, report that 26.1% contain security vulnerabilities. Our own full-catalog census is published as a citable open dataset.

Sources & who's responsible:

View on GitHub → Browse Agent Tool tools