ashiqstudio
demo · runs in your browser · no database connected pip install ashiq
What this is. A demo of ashiq, running entirely in this browser tab on six invented example schemas. It is not connected to any database and does not call any AI model. The real thing is pip install ashiq, which runs on your own database.
The one thing to see. A user only gets the tables they are allowed to see — before the model writes any SQL.
Selected
Prompt tokens
Saved vs full schema
pre-written examples of what a model would produce — no model is called on this page. With your own key, cat.describe(...) generates these for real.

Selected objects

    What the model receives

    
          

    Hidden from this caller

    These exist in the catalog but never reach the prompt for this identity. Not de-ranked — absent.

    Backup and staging copies demoted

    A copy carries the same name words in a shorter document, and cosine similarity rewards exactly that. These are ranked below the object they shadow — unless you name them outright.

    Use it from Python

    pip install ashiq
    
    from ashiq import Catalog, Principal
    cat = Catalog().bootstrap("postgresql://localhost/app")
    cat.select("revenue by month",
               principal=Principal("okta:jdoe", roles={"finance"}))

    Use it from Claude Desktop, Cursor, any MCP client

    pip install 'ashiq[mcp]'
    ASHIQ_DATABASE_URL=postgresql://localhost/app \
      python -m ashiq.mcp_server

    Run this studio on your own database

    pip install ashiq
    ashiq studio --url postgresql://localhost/app

    Same page, your schema, nothing leaves your machine. github.com/ashishsinha1602/ashiq · Apache-2.0 · Ashish Sinha