schemaspy
PMapper
| schemaspy | PMapper | |
|---|---|---|
| 17 | 7 | |
| 3,014 | 1,323 | |
| 1.5% | 0.5% | |
| 9.4 | 0.0 | |
| 4 days ago | 6 months ago | |
| HTML | Python | |
| GNU Lesser General Public License v3.0 only | GNU Affero General Public License v3.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
schemaspy
- Show HN: Open source database diagram editor
-
SQLite Schema Diagram Generator
You might try https://schemaspy.org/ - it generates a website with ER diagrams that only go one or two relationships out, but they have clickable table names to get to the next diagram
- Document your database simply and easily
-
DE new on the job
I had the same problem when i started my job. I used SchemaSpy to generate an html with all of metadata and ERD diagrams as a reference point. Then i used dbt to connect to the database and used dbt to document the table and column that i have worked on. It takes time to document but it's worth it if you company don't have your database documented yet.
-
Spring, SchemaSpy DB docs, and GitHub Pages
SchemaSpy is a standalone application that connects to the database, scans its tables and schemas, and generated nicely composed HTML documentation. You can check out an example sample by this link but I'm showing you just one screenshot to clarify my point.
-
pgAdmin Generate ERD stuck on load
I like https://schemaspy.org/
- Tips on investigating new databases with minimal documentation?
-
Looking for a database documenting tool to generate docs for analysts
I like the diagrams and reports SchemaSpy generates. If you are using a DBMS that allows setting comments to tables, views, columns (and other objects), those will be included and that makes those reports even more helpful
- What some of your recommended database mappers?
-
Schema to dia/UML/etc/whatever
https://schemaspy.org/ creates nice looking diagrams.
PMapper
-
How to conduct security assesment of AWS?
In addition to ScoutSuite, I recommend PMapper. https://github.com/nccgroup/PMapper
-
Anyone tried to create a halfway decent least privilege policy for a CDK deployment?
There are tons of other escape hatches, so it's a pretty big moving target. If you'd like to get a hint about your setup, I'd suggest trying: https://github.com/nccgroup/PMapper
- Do you know a way to visulize access flow between users and resources?
-
Graphviz: Open-source graph visualization software
I maintain an open-source project [1] that uses graphs to model data. I wanted to make my project as accessible as possible, so Graphviz was perfect since it's dead-simple to install and use on all major OS platforms.
[1] https://github.com/nccgroup/PMapper
- Principal Mapper v1.1.0 - AWS IAM Security Analysis
-
Show HN: Principal Mapper v1.1.0 – AWS IAM Security Analysis
Hi HN!
Principal Mapper is a tool + library for analyzing and securing your AWS IAM configuration. It generates a model of your account and/or organization and uses it to give you a better idea of the effective permissions of your IAM Users and Roles. It has privilege escalation detection built-in and is hopefully written in a way that will let you extend it for your use-cases.
This v1.1.0 update covers more types of policies (resource policies, permission boundaries, session policies, SCPs), supports AWS Organizations, enables cross-account checks, and more!
https://github.com/nccgroup/PMapper
Happy to answer any questions you have here!
What are some alternatives?
plantuml - Generate diagrams from textual description
awesome-aws - A curated list of awesome Amazon Web Services (AWS) libraries, open source repos, guides, blogs, and other resources. Featuring the Fiery Meter of AWSome.
dbml - Database Markup Language (DBML), designed to define and document database structures
data-science-ipython-notebooks - Data science Python notebooks: Deep learning (TensorFlow, Theano, Caffe, Keras), scikit-learn, Kaggle, big data (Spark, Hadoop MapReduce, HDFS), matplotlib, pandas, NumPy, SciPy, Python essentials, AWS, and various command lines.
Postico - Public issue tracking for Postico
policy_sentry - IAM Least Privilege Policy Generator
graphviz
aws-leastprivilege - Generates an IAM policy for the CloudFormation service role that adheres to least privilege.
mermaid - Generation of diagrams like flowcharts or sequence diagrams from text in a similar manner as markdown
AirIAM - Least privilege AWS IAM Terraformer
sketchviz-docker - Graphviz -> Sketchy PNG in one image, for automation
d3-dag - Layout algorithms for visualizing directed acyclic graphs