Average Ratings 0 Ratings
Average Ratings 0 Ratings
Description
DynoTable is a desktop GUI designed for macOS (Apple Silicon), Windows, and Linux (.deb/.rpm) that operates locally and interfaces with Amazon DynamoDB and Amazon OpenSearch. With its SQL Workbench, users can execute real SELECT queries, including complex operations like JOINs, GROUP BY, and various aggregations on live tables and OpenSearch indices, allowing for the seamless integration of tables and indices in a single query. Before execution, it provides a compiled plan that distinguishes between Scan and Query with the selected index, enhancing user understanding of query performance. The Smart Tables feature enables joining tables based on a primary key or any global secondary index, with real-time recomputation ensuring data accuracy. Additionally, OpenSearch Service domains and Serverless collections can be accessed alongside tables, featuring capabilities such as Lucene search, autocomplete, and document edits that are managed similarly to item edits. An integrated AI agent operates using your own Amazon Bedrock keys, ensuring that no prompt, schema, or row information is stored outside your AWS account. Moreover, tools like Claude Code, Cursor, and Codex are able to connect through MCP, with all modifications requiring your review and approval in a staging window. Importantly, DynoTable employs your personal AWS credentials without necessitating a server in between, and it is compatible with AWS SSO, aws-vault, and DynamoDB Local, offering a comprehensive solution for managing your AWS database environments. This robust functionality makes DynoTable an essential tool for developers and data analysts working with AWS services.
Description
Python-SQL is a library designed to facilitate the writing of SQL queries in a more Pythonic manner, supporting a variety of functionalities such as basic selects, selections with where clauses, and complex joins including multiple joins. It allows for groupings and output naming, alongside ordering results and executing sub-selects, while also enabling queries on different schemas. The library is capable of performing insert operations with default values, specific values, or even using another query for insertion. Furthermore, it accommodates updates with specified values, conditions, or lists, as well as deletions based on conditions or sub-queries. Additionally, it offers different query styles including limit style, qmark style, and numeric style to cater to diverse programming needs. This versatility makes Python-SQL a powerful tool for developers working with databases in a Python environment.
API Access
Has API
No
API Access
Has API
Yes
Integrations
Amazon DynamoDB
Yes
Domino Enterprise AI Platform
No
Python
No
Visplore
No
Integrations
Amazon DynamoDB
No
Domino Enterprise AI Platform
Yes
Python
Yes
Visplore
Yes
Pricing Details
$9/seat/month billed annually
Free Trial
Yes
Free Version
Yes
Pricing Details
Free
Free Trial
No
Free Version
Yes
Deployment
Web-Based
No
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
Yes
Mac
Yes
Linux
Yes
Chromebook
No
Deployment
Web-Based
No
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
Yes
Mac
Yes
Linux
Yes
Chromebook
No
Customer Support
Business Hours
No
Live Rep (24/7)
No
Online Support
Yes
Customer Support
Business Hours
No
Live Rep (24/7)
No
Online Support
Yes
Types of Training
Training Docs
Yes
Webinars
No
Live Training (Online)
No
In Person
No
Types of Training
Training Docs
Yes
Webinars
Yes
Live Training (Online)
No
In Person
No
Vendor Details
Company Name
DynoTable
Founded
2026
Country
Spain
Website
dynotable.com
Vendor Details
Company Name
Python Software Foundation
Country
United States
Website
pypi.org/project/python-sql/